PostgreSQL 9.1 → 9.2 GUC 差异

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

说明

Fact。 实测在档数从 219 变为 224；新增 8、boot 默认值变化 4、移除 3。

新增参数

参数	类型	Context	Boot 默认值	分类
`enable_indexonlyscan`	`bool`	`user`	`on`	Query Tuning / Planner Method Configuration
`event_source`	`string`	`postmaster`	`PostgreSQL`	Reporting and Logging / Where to Log
`ssl_ca_file`	`string`	`postmaster`	`""` (empty string)	Connections and Authentication / Security and Authentication
`ssl_cert_file`	`string`	`postmaster`	`server.crt`	Connections and Authentication / Security and Authentication
`ssl_crl_file`	`string`	`postmaster`	`""` (empty string)	Connections and Authentication / Security and Authentication
`ssl_key_file`	`string`	`postmaster`	`server.key`	Connections and Authentication / Security and Authentication
`temp_file_limit`	`integer`	`superuser`	`-1 kB`	Resource Usage / Disk
`track_io_timing`	`bool`	`superuser`	`off`	Statistics / Query and Index Statistics Collector

Boot 默认值变化

参数	PG9.1	PG9.2	分类
`TimeZone`	— (not set)	`GMT`	Client Connection Defaults / Locale and Formatting
`log_timezone`	— (not set)	`GMT`	Reporting and Logging / What to Log
`server_version`	`9.1.24`	`9.2.23`	Preset Options
`server_version_num`	`90124`	`90223`	Preset Options

移除参数

参数	最后类型	Context	最后 Boot 默认值	分类
`custom_variable_classes`	`string`	`sighup`	— (not set)	Customized Options
`silent_mode`	`bool`	`postmaster`	`off`	Reporting and Logging / Where to Log
`wal_sender_delay`	`integer`	`sighup`	`1000 ms` (1 s)	Replication / Master Server

计算方法

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