Select two versions of Postgres to see the differences between their
postgresql.conf parameters and defaults. Parameters that remain
the same in both versions are not displayed.
Upgrade from to
Updated: 5
New: 6
Removed: 1
Updated Parameters
Category
Description
Changed:
history_url
name
hash_mem_multiplier
Resource Usage / Memory
Multiple of work_mem to use for hash tables.
Default value: 1 -> 2
log_autovacuum_min_duration
Reporting and Logging / What to Log
Sets the minimum execution time above which autovacuum actions will be logged.
Default value: -1 -> 600000
log_checkpoints
Reporting and Logging / What to Log
Logs each checkpoint.
Default value: off -> on
shared_buffers
Resource Usage / Memory
Sets the number of shared memory buffers used by the server.
Default value: 1024 -> 16384
wal_compression
Write-Ahead Log / Settings
Compresses full-page writes written in WAL file with specified method.
Variable type: bool -> enum
New Parameters
Category
Description
Default Value
Var Type
Enum Values
history_url
name
archive_library
Write-Ahead Log / Archiving
Sets the library that will be called to archive a WAL file.
string
None
log_startup_progress_interval
Reporting and Logging / When to Log
Time between progress updates for long-running startup operations.
10000 ms
integer
None
recovery_prefetch
Write-Ahead Log / Recovery
Prefetch referenced blocks during recovery.
try
enum
[off, on, try]
recursive_worktable_factor
Query Tuning / Other Planner Options
Sets the planner's estimate of the average size of a recursive query's working table.
10
real
None
stats_fetch_consistency
Statistics / Cumulative Query and Index Statistics
Sets the consistency of accesses to statistics data.
cache
enum
[none, cache, snapshot]
wal_decode_buffer_size
Write-Ahead Log / Recovery
Buffer size for reading ahead in the WAL during recovery.
524288 B
integer
None
Removed Parameters
Category
Description
Default Value
Var Type
Enum Values
history_url
name
stats_temp_directory
Statistics / Query and Index Statistics Collector
Writes temporary statistics files to the specified directory.
postgresql.conf comparison