PostgreSQL 9.1 → 9.2 GUC diff
Core configuration parameters added, removed, or changed in boot default between PostgreSQL 9.1 and 9.2.
Note
Fact. The measured inventory changes from 219 to 224 settings: 8 added, 4 boot-default changes, and 3 removed.
Added parameters
| Parameter | Type | Context | Boot default | Category |
|---|---|---|---|---|
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-default changes
| Parameter | PG9.1 | PG9.2 | Category |
|---|---|---|---|
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 |
Removed parameters
| Parameter | Last type | Context | Last boot default | Category |
|---|---|---|---|---|
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 |
Method
The three lists compare the pinned PG9.1 and PG9.2 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.