PostgreSQL 10 → 11 GUC diff

Core configuration parameters added, removed, or changed in boot default between PostgreSQL 10 and 11.

Note

Fact. The measured inventory changes from 272 to 292 settings: 21 added, 4 boot-default changes, and 1 removed.

Added parameters

Parameter	Type	Context	Boot default	Category
`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-default changes

Parameter	PG10	PG11	Category
`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

Removed parameters

Parameter	Last type	Context	Last boot default	Category
`replacement_sort_tuples`	`integer`	`user`	`150000`	Resource Usage / Memory

Method

The three lists compare the pinned PG10 and PG11 pg_settings snapshots directly. A default change is a change in the boot_val plus unit pair; setting is excluded so an initdb-generated value is not mistaken for the compiled boot default.