PostgreSQL 13 → 14 GUC diff
Core configuration parameters added, removed, or changed in boot default between PostgreSQL 13 and 14.
Note
Fact. The measured inventory changes from 332 to 348 settings: 18 added, 5 boot-default changes, and 2 removed.
Added parameters
| Parameter | Type | Context | Boot default | Category |
|---|---|---|---|---|
client_connection_check_interval |
integer |
user |
0 ms |
Connections and Authentication / Connection Settings |
compute_query_id |
enum |
superuser |
auto |
Statistics / Monitoring |
debug_discard_caches |
integer |
superuser |
0 |
Developer Options |
default_toast_compression |
enum |
user |
pglz |
Client Connection Defaults / Statement Behavior |
enable_async_append |
bool |
user |
on |
Query Tuning / Planner Method Configuration |
enable_memoize |
bool |
user |
on |
Query Tuning / Planner Method Configuration |
huge_page_size |
integer |
postmaster |
0 kB (0 B) |
Resource Usage / Memory |
idle_session_timeout |
integer |
user |
0 ms |
Client Connection Defaults / Statement Behavior |
in_hot_standby |
bool |
internal |
off |
Preset Options |
log_recovery_conflict_waits |
bool |
sighup |
off |
Reporting and Logging / What to Log |
min_dynamic_shared_memory |
integer |
postmaster |
0 MB (0 B) |
Resource Usage / Memory |
output_plugin_libraries |
string |
superuser |
pgoutput, test_decoding |
Replication / Sending Servers |
recovery_init_sync_method |
enum |
sighup |
fsync |
Error Handling |
remove_temp_files_after_crash |
bool |
sighup |
on |
Developer Options |
ssl_crl_dir |
string |
sighup |
"" (empty string) |
Connections and Authentication / SSL |
track_wal_io_timing |
bool |
superuser |
off |
Statistics / Query and Index Statistics Collector |
vacuum_failsafe_age |
integer |
user |
1600000000 |
Client Connection Defaults / Statement Behavior |
vacuum_multixact_failsafe_age |
integer |
user |
1600000000 |
Client Connection Defaults / Statement Behavior |
Boot-default changes
| Parameter | PG13 | PG14 | Category |
|---|---|---|---|
checkpoint_completion_target |
0.5 |
0.9 |
Write-Ahead Log / Checkpoints |
password_encryption |
md5 |
scram-sha-256 |
Connections and Authentication / Authentication |
server_version |
13.23 (Debian 13.23-1.pgdg13+1) |
14.24 (Debian 14.24-1.pgdg13+2) |
Preset Options |
server_version_num |
130023 |
140024 |
Preset Options |
vacuum_cost_page_miss |
10 |
2 |
Resource Usage / Cost-Based Vacuum Delay |
Removed parameters
| Parameter | Last type | Context | Last boot default | Category |
|---|---|---|---|---|
operator_precedence_warning |
bool |
user |
off |
Version and Platform Compatibility / Previous PostgreSQL Versions |
vacuum_cleanup_index_scale_factor |
real |
user |
0.1 |
Client Connection Defaults / Statement Behavior |
Method
The three lists compare the pinned PG13 and PG14 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.