PostgreSQL 9.4 → 9.5 GUC 差异

PG9.4 与 PG9.5 之间新增、boot 默认值变化和移除的核心配置参数。

说明

Fact。 实测在档数从 240 变为 249；新增 11、boot 默认值变化 3、移除 2。

新增参数

参数	类型	Context	Boot 默认值	分类
`cluster_name`	`string`	`postmaster`	`""` (empty string)	Process Title
`extension_destdir`	`string`	`superuser`	`""` (empty string)	File Locations
`gin_pending_list_limit`	`integer`	`user`	`4096 kB` (4 MiB)	Client Connection Defaults / Statement Behavior
`log_replication_commands`	`bool`	`superuser`	`off`	Reporting and Logging / What to Log
`max_wal_size`	`integer`	`sighup`	`64 16MB` (1 GiB (64 × 16MB))	Write-Ahead Log / Checkpoints
`min_wal_size`	`integer`	`sighup`	`5 16MB` (80 MiB (5 × 16MB))	Write-Ahead Log / Checkpoints
`operator_precedence_warning`	`bool`	`user`	`off`	Version and Platform Compatibility / Previous PostgreSQL Versions
`row_security`	`bool`	`user`	`on`	Connections and Authentication / Security and Authentication
`track_commit_timestamp`	`bool`	`postmaster`	`off`	Replication
`wal_compression`	`bool`	`superuser`	`off`	Write-Ahead Log / Settings
`wal_retrieve_retry_interval`	`integer`	`sighup`	`5000 ms` (5 s)	Replication / Standby Servers

Boot 默认值变化

参数	PG9.4	PG9.5	分类
`search_path`	`"$user",public`	`"$user", public`	Client Connection Defaults / Statement Behavior
`server_version`	`9.4.26`	`9.5.25`	Preset Options
`server_version_num`	`90426`	`90525`	Preset Options

移除参数

参数	最后类型	Context	最后 Boot 默认值	分类
`checkpoint_segments`	`integer`	`sighup`	`3`	Write-Ahead Log / Checkpoints
`ssl_renegotiation_limit`	`integer`	`user`	`0 kB` (0 B)	Connections and Authentication / Security and Authentication

计算方法

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