autovacuum_max_workers |
[5-20] |
是 |
Sets the maximum number of simultaneously running autovacuum worker processes. |
autovacuum_vacuum_cost_delay |
[-1-100] |
否 |
Vacuum cost delay in milliseconds, for autovacuum. |
autovacuum_vacuum_cost_limit |
[-1-10000] |
否 |
Vacuum cost amount available before napping, for autovacuum. |
auto_explain.log_analyze |
[on|off] |
否 |
Use EXPLAIN ANALYZE for plan logging. |
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] |
否 |
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. |
default_transaction_deferrable |
[on|off] |
否 |
Sets the default deferrable status of new transactions. |
enable_partitionwise_aggregate |
[on|off] |
否 |
Enables partitionwise aggregation and grouping. |
enable_partitionwise_join |
[on|off] |
否 |
Enables partitionwise join. |
extra_float_digits |
[-15-3] |
否 |
Sets the number of digits displayed for floating-point values. |
idle_in_transaction_session_timeout |
0或者[1000-2000000000] |
否 |
Sets the maximum allowed duration of any idling transaction. |
jit |
[on|off] |
否 |
Allow JIT compilation. |
lock_timeout |
0或者[1000-2000000000] |
否 |
Sets the maximum allowed duration of any wait for a lock. |
log_min_duration_statement |
[-1-2147483647] |
否 |
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] |
否 |
Log the use of temporary files larger than this number of kilobytes. |
max_parallel_workers |
[0-512] |
否 |
Sets the maximum number of parallel workers that can be active at one time. |
max_parallel_workers_per_gather |
[0-512] |
否 |
Sets the maximum number of parallel processes per executor node. |
max_sync_workers_per_subscription |
[0-262143] |
否 |
Maximum number of table synchronization workers per subscription. |
min_parallel_index_scan_size |
[0-715827882] |
否 |
Sets the minimum amount of index data for a parallel scan. |
min_parallel_table_scan_size |
[0-715827882] |
否 |
Sets the minimum amount of table data for a parallel scan. |
old_snapshot_threshold |
[-1-86400] |
是 |
Time before a snapshot is too old to read pages changed after the snapshot was taken. |
polar_comp_dynatune |
[0-100] |
是 |
Sets the polardb utilization percentage. |
polar_comp_dynatune_profile |
[oltp|reporting|mixed] |
是 |
Sets the workload profile for dynatune. |
polar_comp_enable_pruning |
[on|off] |
否 |
Enables the planner to early-prune partitioned tables. |
polar_comp_redwood_date |
[on|off] |
否 |
Determines whether DATE should behave like e TIMESTAMP or not. |
polar_comp_redwood_greatest_least |
[on|off] |
否 |
Determines whether GREATEST AND LEAST function should behave like Redwood or PG. |
polar_comp_redwood_raw_names |
[on|off] |
否 |
Return the unmodified name stored in the PostgreSQL system catalogs from Redwood interfaces. |
polar_comp_redwood_strings |
[on|off] |
否 |
Treat NULL as an empty string when concatenated with a TEXT value. |
polar_comp_stmt_level_tx |
[on|off] |
否 |
Allows continuing on errors instead of requiring a transaction abort. |
statement_timeout |
0或者[1000-2000000000] |
否 |
Sets the maximum allowed duration of any statement. |
temp_file_limit |
[-1-1048576000] |
否 |
Limits the total size of all temporary files used by each process. |
timezone |
^'(((UTC)(-){0,1}(d|[1-9]d|1([0-5]d|6[0-7])))|((GMT)(-){0,1}(d|[1-9]d|1([0-5]d|6[0-7])))|CST6CDT|Poland|Kwajalein|MST|NZ|Universal|Libya|Turkey|EST5EDT|Greenwich|NZ-CHAT|MET|Portugal|GMT-0|CET|Eire|PST8PDT|Jamaica|GMT|Zulu|Japan|ROC|GB-Eire|ROK|Navajo|Singapore|posixrules|GB|EST|GMT0|Hongkong|PRC|Iran|MST7MDT|WET|W-SU|UCT|Cuba|Egypt|EET|Israel|UTC|HST|Iceland)'$ |
否 |
Sets the time zone for displaying and interpreting time stamps. |
track_commit_timestamp |
[on|off] |
是 |
Collects transaction commit time. |
vacuum_defer_cleanup_age |
[0-1000000] |
否 |
Number of transactions by which VACUUM and HOT cleanup should be deferred, if any. |
wal_level |
[replica|logical] |
是 |
Set the level of information written to the WAL. |
work_mem |
[4096-524288] |
否 |
Sets the maximum memory to be used for query workspaces. |