自定义参数介绍
以下为您介绍自定义参数。
name | optional | unit | comment |
---|---|---|---|
autovacuum_analyze_scale_factor | [0-1] | Number of tuple inserts, updates, or deletes prior to analyze as a fraction of reltuples. | |
autovacuum_analyze_threshold | [0-2147483647] | Minimum number of tuple inserts, updates, or deletes prior to analyze. | |
autovacuum_freeze_max_age | [200000000-1500000000] | Age at which to autovacuum a table to prevent transaction ID wraparound. | |
autovacuum_max_workers | [5-20] | Sets the maximum number of simultaneously running autovacuum worker processes. | |
autovacuum_vacuum_cost_delay | [-1-100] | ms | Vacuum cost delay in milliseconds, for autovacuum. |
autovacuum_vacuum_cost_limit | [-1-10000] | Vacuum cost amount available before napping, for autovacuum. | |
autovacuum_vacuum_scale_factor | [0-1] | Number of tuple updates or deletes prior to vacuum as a fraction of reltuples. | |
autovacuum_vacuum_threshold | [0-2147483647] | Minimum number of tuple updates or deletes prior to vacuum. | |
checkpoint_completion_target | [0-1] | Time spent flushing dirty buffers during checkpoint, as fraction of checkpoint interval. | |
checkpoint_timeout | [30-86400] | s | Sets the maximum time between automatic WAL checkpoints. |
checkpoint_warning | [30-2147483647] | s | Enables warnings if checkpoint segments are filled more frequently than this. |
commit_delay | [0-100000] | Sets the delay in microseconds between transaction commit and flushing WAL to disk. | |
commit_siblings | [0-1000] | Sets the minimum concurrent open transactions before performing commit_delay. | |
default_statistics_target | [1-10000] | Sets the default statistics target. | |
default_transaction_deferrable | [on|off] | Sets the default deferrable status of new transactions. | |
enable_bitmapscan | [on|off] | Enables the planner's use of bitmap-scan plans. | |
enable_gathermerge | [on|off] | Enables the planner's use of gather merge plans. | |
enable_hashagg | [on|off] | Enables the planner's use of hashed aggregation plans. | |
enable_hashjoin | [on|off] | Enables the planner's use of hash join plans. | |
enable_indexonlyscan | [on|off] | Enables the planner's use of index-only-scan plans. | |
enable_indexscan | [on|off] | Enables the planner's use of index-scan plans. | |
enable_material | [on|off] | Enables the planner's use of materialization. | |
enable_mergejoin | [on|off] | Enables the planner's use of merge join plans. | |
enable_nestloop | [on|off] | Enables the planner's use of nested-loop join plans. | |
enable_parallel_append | [on|off] | Enables the planner's use of parallel append plans. | |
enable_parallel_hash | [on|off] | Enables the planner's use of parallel hash plans. | |
enable_partition_pruning | [on|off] | Enable plan-time and run-time partition pruning. | |
enable_partitionwise_aggregate | [on|off] | Enables partitionwise aggregation and grouping. | |
enable_partitionwise_join | [on|off] | Enables partitionwise join. | |
enable_seqscan | [on|off] | Enables the planner's use of sequential-scan plans. | |
enable_sort | [on|off] | Enables the planner's use of explicit sort steps. | |
enable_tidscan | [on|off] | Enables the planner's use of TID scan plans. | |
gin_fuzzy_search_limit | [0-2147483647] | Sets the maximum allowed result for exact search by GIN. | |
gin_pending_list_limit | [64-2147483647] | kB | Sets the maximum size of the pending list for GIN index. |
auto_explain.log_analyze | [on|off] | Use EXPLAIN ANALYZE for plan logging. | |
lock_timeout | [0-2147483647] | ms | Sets the maximum allowed duration of any wait for a lock. |
log_autovacuum_min_duration | [-1-2147483647] | ms | Sets the minimum execution time above which autovacuum actions will be logged. |
log_checkpoints | [on|off] | Logs each checkpoint. | |
log_connections | [on|off] | Logs each successful connection. | |
log_disconnections | [on|off] | Logs end of a session, including duration. | |
log_min_duration_statement | [-1-2147483647] | ms | Sets the minimum execution time above which statements will be logged. |
log_statement | [none,ddl,mod,all] | Sets the type of statements logged. | |
log_temp_files | [-1-2147483647] | kB | Log the use of temporary files larger than this number of kilobytes. |
max_standby_archive_delay | [-1-2147483647] | ms | Sets the maximum delay before canceling queries when a hot standby server is processing archived WAL data. |
max_standby_streaming_delay | [-1-2147483647] | ms | Sets the maximum delay before canceling queries when a hot standby server is processing streamed WAL data. |
max_sync_workers_per_subscription | [0-262143] | Maximum number of table synchronization workers per subscription. | |
min_parallel_index_scan_size | [0-715827882] | 8kB | Sets the minimum amount of index data for a parallel scan. |
min_parallel_table_scan_size | [0-715827882] | 8kB | Sets the minimum amount of table data for a parallel scan. |
old_snapshot_threshold | [-1-86400] | min | Time before a snapshot is too old to read pages changed after the snapshot was taken. |
statement_timeout | [0-2147483647] | ms | Sets the maximum allowed duration of any statement. |
track_activity_query_size | [100-102400] | B | Sets the size reserved for pg_stat_activity.query, in bytes. |
vacuum_cleanup_index_scale_factor | [0-10000000000] | Number of tuple inserts prior to index cleanup as a fraction of reltuples. | |
vacuum_freeze_table_age | [150000000-2000000000] | Age at which VACUUM should scan whole table to freeze tuples. | |
wal_keep_segments | [0-100000] | Sets the number of WAL files held for standby servers. | |
wal_level | [minimal,replica,logical] | Set the level of information written to the WAL. | |
auto_explain.log_buffers | [on|off] | Log buffers usage. | |
auto_explain.log_format | [text,xml,json,yaml] | EXPLAIN format to be used for plan logging. | |
auto_explain.log_min_duration | [-1-2147483647] | ms | Sets the minimum execution time above which plans will be logged. |
auto_explain.log_nested_statements | [on|off] | Log nested statements. | |
auto_explain.log_timing | [on|off] | Collect timing data, not just row counts. | |
auto_explain.log_triggers | [on|off] | Include trigger statistics in plans. | |
auto_explain.log_verbose | [on|off] | Use EXPLAIN VERBOSE for plan logging. | |
auto_explain.sample_rate | [0-1] | Fraction of queries to process. | |
parallel_setup_cost | [0-2147483647] | Sets the planner's estimate of the cost of starting up worker processes for parallel query. | |
parallel_tuple_cost | [0-2147483647] | Sets the planner's estimate of the cost of passing each tuple (row) from worker to master backend. | |
work_mem | [1024-1048576] | kB | Sets the maximum memory to be used for query workspaces. |
idle_in_transaction_session_timeout | [0-2147483647] | ms | Sets the maximum allowed duration of any idling transaction. |
版权声明
本文仅代表作者观点,不代表本站立场。
本文系作者授权发表,未经许可,不得转载。
评论