PostgreSQL 10 → 11 GUC 差异

PG10 与 PG11 之间新增、boot 默认值变化和移除的核心配置参数。

说明

Fact。 实测在档数从 272 变为 292；新增 21、boot 默认值变化 4、移除 1。

新增参数

参数	类型	Context	Boot 默认值	分类
`data_directory_mode`	`integer`	`internal`	`448`	Preset Options
`enable_parallel_append`	`bool`	`user`	`on`	Query Tuning / Planner Method Configuration
`enable_parallel_hash`	`bool`	`user`	`on`	Query Tuning / Planner Method Configuration
`enable_partition_pruning`	`bool`	`user`	`on`	Query Tuning / Planner Method Configuration
`enable_partitionwise_aggregate`	`bool`	`user`	`off`	Query Tuning / Planner Method Configuration
`enable_partitionwise_join`	`bool`	`user`	`off`	Query Tuning / Planner Method Configuration
`jit`	`bool`	`user`	`off`	Query Tuning / Other Planner Options
`jit_above_cost`	`real`	`user`	`100000`	Query Tuning / Planner Cost Constants
`jit_debugging_support`	`bool`	`superuser-backend`	`off`	Developer Options
`jit_dump_bitcode`	`bool`	`superuser`	`off`	Developer Options
`jit_expressions`	`bool`	`user`	`on`	Developer Options
`jit_inline_above_cost`	`real`	`user`	`500000`	Query Tuning / Planner Cost Constants
`jit_optimize_above_cost`	`real`	`user`	`500000`	Query Tuning / Planner Cost Constants
`jit_profiling_support`	`bool`	`superuser-backend`	`off`	Developer Options
`jit_provider`	`string`	`postmaster`	`llvmjit`	Client Connection Defaults / Shared Library Preloading
`jit_tuple_deforming`	`bool`	`user`	`on`	Developer Options
`max_parallel_maintenance_workers`	`integer`	`user`	`2`	Resource Usage / Asynchronous Behavior
`parallel_leader_participation`	`bool`	`user`	`on`	Resource Usage / Asynchronous Behavior
`ssl_passphrase_command`	`string`	`sighup`	`""` (empty string)	Connections and Authentication / SSL
`ssl_passphrase_command_supports_reload`	`bool`	`sighup`	`off`	Connections and Authentication / SSL
`vacuum_cleanup_index_scale_factor`	`real`	`user`	`0.1`	Client Connection Defaults / Statement Behavior

Boot 默认值变化

参数	PG10	PG11	分类
`server_version`	`10.23 (Debian 10.23-1.pgdg110+1)`	`11.22 (Debian 11.22-1.pgdg120+1)`	Preset Options
`server_version_num`	`100023`	`110022`	Preset Options
`track_activity_query_size`	`1024`	`1024 B` (1 KiB)	Resource Usage / Memory
`wal_segment_size`	`2048 8kB` (16 MiB (2048 × 8kB))	`16777216 B` (16 MiB)	Preset Options

移除参数

参数	最后类型	Context	最后 Boot 默认值	分类
`replacement_sort_tuples`	`integer`	`user`	`150000`	Resource Usage / Memory

计算方法

三张清单直接比较固定环境中的 PG10 与 PG11 pg_settings 快照。默认值变化使用 boot_val 与 unit 的组合；setting 不参与判定，以免把 initdb 生成值误当作编译时默认值。