Skip to content

PostgreSQL 14 → 15 GUC diff

Core configuration parameters added, removed, or changed in boot default between PostgreSQL 14 and 15.
Note

Fact. The measured inventory changes from 348 to 355 settings: 8 added, 6 boot-default changes, and 1 removed.

Added parameters

Parameter Type Context Boot default Category
archive_library string sighup "" (empty string) Write-Ahead Log / Archiving
log_startup_progress_interval integer sighup 10000 ms (10 s) Reporting and Logging / When to Log
recovery_prefetch enum sighup try Write-Ahead Log / Recovery
recursive_worktable_factor real user 10 Query Tuning / Other Planner Options
shared_memory_size integer internal 0 MB (0 B) Preset Options
shared_memory_size_in_huge_pages integer internal -1 Preset Options
stats_fetch_consistency enum user cache Statistics / Cumulative Query and Index Statistics
wal_decode_buffer_size integer postmaster 524288 B (512 KiB) Write-Ahead Log / Recovery

Boot-default changes

Parameter PG14 PG15 Category
hash_mem_multiplier 1 2 Resource Usage / Memory
log_autovacuum_min_duration -1 ms 600000 ms (10 min) Reporting and Logging / What to Log
log_checkpoints off on Reporting and Logging / What to Log
server_version 14.24 (Debian 14.24-1.pgdg13+2) 15.19 (Debian 15.19-1.pgdg13+2) Preset Options
server_version_num 140024 150019 Preset Options
shared_buffers 1024 8kB (8 MiB (1024 × 8kB)) 16384 8kB (128 MiB (16384 × 8kB)) Resource Usage / Memory

Removed parameters

Parameter Last type Context Last boot default Category
stats_temp_directory string sighup pg_stat_tmp Statistics / Query and Index Statistics Collector

Method

The three lists compare the pinned PG14 and PG15 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.