PostgreSQL 12 → 13 GUC 差异

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

说明

Fact。 实测在档数从 317 变为 332；新增 16、boot 默认值变化 3、移除 1。

新增参数

参数	类型	Context	Boot 默认值	分类
`autovacuum_vacuum_insert_scale_factor`	`real`	`sighup`	`0.2`	Autovacuum
`autovacuum_vacuum_insert_threshold`	`integer`	`sighup`	`1000`	Autovacuum
`backtrace_functions`	`string`	`superuser`	`""` (empty string)	Developer Options
`enable_incremental_sort`	`bool`	`user`	`on`	Query Tuning / Planner Method Configuration
`hash_mem_multiplier`	`real`	`user`	`1`	Resource Usage / Memory
`ignore_invalid_pages`	`bool`	`postmaster`	`off`	Developer Options
`log_min_duration_sample`	`integer`	`superuser`	`-1 ms`	Reporting and Logging / When to Log
`log_parameter_max_length`	`integer`	`superuser`	`-1 B`	Reporting and Logging / What to Log
`log_parameter_max_length_on_error`	`integer`	`user`	`0 B`	Reporting and Logging / What to Log
`log_statement_sample_rate`	`real`	`superuser`	`1`	Reporting and Logging / When to Log
`logical_decoding_work_mem`	`integer`	`user`	`65536 kB` (64 MiB)	Resource Usage / Memory
`maintenance_io_concurrency`	`integer`	`user`	`10`	Resource Usage / Asynchronous Behavior
`max_slot_wal_keep_size`	`integer`	`sighup`	`-1 MB`	Replication / Sending Servers
`wal_keep_size`	`integer`	`sighup`	`0 MB` (0 B)	Replication / Sending Servers
`wal_receiver_create_temp_slot`	`bool`	`sighup`	`off`	Replication / Standby Servers
`wal_skip_threshold`	`integer`	`user`	`2048 kB` (2 MiB)	Write-Ahead Log / Settings

Boot 默认值变化

参数	PG12	PG13	分类
`server_version`	`12.22 (Debian 12.22-1.pgdg120+1)`	`13.23 (Debian 13.23-1.pgdg13+1)`	Preset Options
`server_version_num`	`120022`	`130023`	Preset Options
`ssl_min_protocol_version`	`TLSv1`	`TLSv1.2`	Connections and Authentication / SSL

移除参数

参数	最后类型	Context	最后 Boot 默认值	分类
`wal_keep_segments`	`integer`	`sighup`	`0`	Replication / Sending Servers

计算方法

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