postgresql.conf comparison

Postgres Config Changes: 16 to 17

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: 1

New: 19

Removed: 3

Updated Parameters

Category Description Changed: history_url
name
vacuum_buffer_usage_limit Resource Usage / Memory Sets the buffer pool size for VACUUM, ANALYZE, and autovacuum. Default value: 256 -> 2048

New Parameters

Category Description Default Value Var Type Enum Values history_url
name
allow_alter_system Version and Platform Compatibility / Other Platforms and Clients Allows running the ALTER SYSTEM command. on bool None
commit_timestamp_buffers Resource Usage / Memory Sets the size of the dedicated buffer pool used for the commit timestamp cache. 0 8kB integer None
enable_group_by_reordering Query Tuning / Planner Method Configuration Enables reordering of GROUP BY keys. on bool None
event_triggers Client Connection Defaults / Statement Behavior Enables event triggers. on bool None
io_combine_limit Resource Usage / Asynchronous Behavior Limit on the size of data reads and writes. 16 8kB integer None
max_notify_queue_pages Resource Usage / Disk Sets the maximum number of allocated pages for NOTIFY / LISTEN queue. 1048576 integer None
multixact_member_buffers Resource Usage / Memory Sets the size of the dedicated buffer pool used for the MultiXact member cache. 32 8kB integer None
multixact_offset_buffers Resource Usage / Memory Sets the size of the dedicated buffer pool used for the MultiXact offset cache. 16 8kB integer None
notify_buffers Resource Usage / Memory Sets the size of the dedicated buffer pool used for the LISTEN/NOTIFY message cache. 16 8kB integer None
restrict_nonsystem_relation_kind Client Connection Defaults / Statement Behavior Prohibits access to non-system relations of specified kinds. string None
serializable_buffers Resource Usage / Memory Sets the size of the dedicated buffer pool used for the serializable transaction cache. 32 8kB integer None
subtransaction_buffers Resource Usage / Memory Sets the size of the dedicated buffer pool used for the subtransaction cache. 0 8kB integer None
summarize_wal Write-Ahead Log / Summarization Starts the WAL summarizer process to enable incremental backup. off bool None
synchronized_standby_slots Replication / Primary Server Lists streaming replication standby server replication slot names that logical WAL sender processes will wait for. string None
sync_replication_slots Replication / Standby Servers Enables a physical standby to synchronize logical failover replication slots from the primary server. off bool None
trace_connection_negotiation Developer Options Logs details of pre-authentication connection handshake. off bool None
transaction_buffers Resource Usage / Memory Sets the size of the dedicated buffer pool used for the transaction status cache. 0 8kB integer None
transaction_timeout Client Connection Defaults / Statement Behavior Sets the maximum allowed duration of any transaction within a session (not a prepared transaction). 0 ms integer None
wal_summary_keep_time Write-Ahead Log / Summarization Time for which WAL summary files should be kept. 14400 min integer None

Removed Parameters

Category Description Default Value Var Type Enum Values history_url
name
db_user_namespace Connections and Authentication / Authentication Enables per-database user names. off bool None
old_snapshot_threshold Resource Usage / Asynchronous Behavior Time before a snapshot is too old to read pages changed after the snapshot was taken. -1 min integer None
trace_recovery_messages Developer Options Enables logging of recovery-related debugging information. log enum [debug5, debug4, debug3, debug2, debug1, log, notice, warning, error]
About this tool
© RustProof Labs, 2025
Maintained by RustProof Labs.