postgresql.conf comparison

Postgres Config Changes: 17 to 18

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

New: 20

Removed: 1

Updated Parameters

Category Description Changed: history_url
name
effective_io_concurrency Resource Usage / I/O Number of simultaneous requests that can be handled efficiently by the disk subsystem. Default value: 1 -> 16
log_connections Reporting and Logging / What to Log Logs specified aspects of connection establishment and setup. Default value: off -> , Variable type: bool -> string
maintenance_io_concurrency Resource Usage / I/O A variant of "effective_io_concurrency" that is used for maintenance work. Default value: 10 -> 16

New Parameters

Category Description Default Value Var Type Enum Values history_url
name
autovacuum_vacuum_max_threshold Vacuuming / Automatic Vacuuming Maximum number of tuple updates or deletes prior to vacuum. 100000000 integer None
autovacuum_worker_slots Vacuuming / Automatic Vacuuming Sets the number of backend slots to allocate for autovacuum workers. 16 integer None
enable_distinct_reordering Query Tuning / Planner Method Configuration Enables reordering of DISTINCT keys. on bool None
enable_self_join_elimination Query Tuning / Planner Method Configuration Enables removal of unique self-joins. on bool None
extension_control_path Client Connection Defaults / Other Defaults Sets the path for extension control files. $system string None
file_copy_method Resource Usage / Disk Selects the file copy method. copy enum [copy, clone]
idle_replication_slot_timeout Replication / Sending Servers Sets the duration a replication slot can remain idle before it is invalidated. 0 s integer None
io_max_combine_limit Resource Usage / I/O Server-wide limit that clamps io_combine_limit. 16 8kB integer None
io_max_concurrency Resource Usage / I/O Max number of IOs that one process can execute simultaneously. -1 integer None
io_method Resource Usage / I/O Selects the method for executing asynchronous I/O. worker enum [sync, worker, io_uring]
io_workers Resource Usage / I/O Number of IO worker processes, for io_method=worker. 3 integer None
log_lock_failures Reporting and Logging / What to Log Logs lock failures. off bool None
max_active_replication_origins Replication / Subscribers Sets the maximum number of active replication origins. 10 integer None
md5_password_warnings Connections and Authentication / Authentication Enables deprecation warnings for MD5 passwords. on bool None
oauth_validator_libraries Connections and Authentication / Authentication Lists libraries that may be called to validate OAuth v2 bearer tokens. string None
ssl_groups Connections and Authentication / SSL Sets the group(s) to use for Diffie-Hellman key exchange. X25519:prime256v1 string None
ssl_tls13_ciphers Connections and Authentication / SSL Sets the list of allowed TLSv1.3 cipher suites. string None
track_cost_delay_timing Statistics / Cumulative Query and Index Statistics Collects timing statistics for cost-based vacuum delay. off bool None
vacuum_max_eager_freeze_failure_rate Vacuuming / Freezing Fraction of pages in a relation vacuum can scan and fail to freeze before disabling eager scanning. 0.03 real None
vacuum_truncate Vacuuming / Default Behavior Enables vacuum to truncate empty pages at the end of the table. on bool None

Removed Parameters

Category Description Default Value Var Type Enum Values history_url
name
ssl_ecdh_curve Connections and Authentication / SSL Sets the curve to use for ECDH. prime256v1 string None
About this tool
© RustProof Labs, 2025
Maintained by RustProof Labs.