以下为您介绍自定义参数。
| 参数名称 | 取值范围 | 是否需要重启 | 说明 |
|---|---|---|---|
| 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. |