以下为您介绍自定义参数。

参数名称 取值范围 是否需要重启 说明
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.