postgresql.conf comparison

Postgres Config Changes: 11 to 12

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

Removed: 1

Updated Parameters

Category Description Changed: history_url
name
autovacuum_vacuum_cost_delay Autovacuum Vacuum cost delay in milliseconds, for autovacuum. Default value: 20 -> 2, Variable type: integer -> real
extra_float_digits Client Connection Defaults / Locale and Formatting Sets the number of digits displayed for floating-point values. Default value: 0 -> 1
jit Query Tuning / Other Planner Options Allow JIT compilation. Default value: off -> on
transaction_isolation Client Connection Defaults / Statement Behavior Sets the current transaction's isolation level. Default value: default -> read committed, Variable type: string -> enum
vacuum_cost_delay Resource Usage / Cost-Based Vacuum Delay Vacuum cost delay in milliseconds. Variable type: integer -> real

New Parameters

Category Description Default Value Var Type Enum Values history_url
name
archive_cleanup_command Write-Ahead Log / Archive Recovery Sets the shell command that will be executed at every restart point. string None
default_table_access_method Client Connection Defaults / Statement Behavior Sets the default table access method for new tables. heap string None
log_transaction_sample_rate Reporting and Logging / When to Log Set the fraction of transactions to log for new transactions. 0 real None
plan_cache_mode Query Tuning / Other Planner Options Controls the planner's selection of custom or generic plan. auto enum [auto, force_generic_plan, force_custom_plan]
primary_conninfo Replication / Standby Servers Sets the connection string to be used to connect to the sending server. string None
primary_slot_name Replication / Standby Servers Sets the name of the replication slot to use on the sending server. string None
promote_trigger_file Replication / Standby Servers Specifies a file name whose presence ends recovery in the standby. string None
recovery_end_command Write-Ahead Log / Archive Recovery Sets the shell command that will be executed once at the end of recovery. string None
recovery_min_apply_delay Replication / Standby Servers Sets the minimum delay for applying changes during recovery. 0 ms integer None
recovery_target Write-Ahead Log / Recovery Target Set to "immediate" to end recovery as soon as a consistent state is reached. string None
recovery_target_action Write-Ahead Log / Recovery Target Sets the action to perform upon reaching the recovery target. pause enum [pause, promote, shutdown]
recovery_target_inclusive Write-Ahead Log / Recovery Target Sets whether to include or exclude transaction with recovery target. on bool None
recovery_target_lsn Write-Ahead Log / Recovery Target Sets the LSN of the write-ahead log location up to which recovery will proceed. string None
recovery_target_name Write-Ahead Log / Recovery Target Sets the named restore point up to which recovery will proceed. string None
recovery_target_time Write-Ahead Log / Recovery Target Sets the time stamp up to which recovery will proceed. string None
recovery_target_timeline Write-Ahead Log / Recovery Target Specifies the timeline to recover into. latest string None
recovery_target_xid Write-Ahead Log / Recovery Target Sets the transaction ID up to which recovery will proceed. string None
restore_command Write-Ahead Log / Archive Recovery Sets the shell command that will retrieve an archived WAL file. string None
shared_memory_type Resource Usage / Memory Selects the shared memory implementation used for the main shared memory region. mmap enum [sysv, mmap]
ssl_max_protocol_version Connections and Authentication / SSL Sets the maximum SSL/TLS protocol version to use. enum [, TLSv1, TLSv1.1, TLSv1.2, TLSv1.3]
ssl_min_protocol_version Connections and Authentication / SSL Sets the minimum SSL/TLS protocol version to use. TLSv1 enum [TLSv1, TLSv1.1, TLSv1.2, TLSv1.3]
tcp_user_timeout Client Connection Defaults / Other Defaults TCP user timeout. 0 ms integer None
wal_init_zero Write-Ahead Log / Settings Writes zeroes to new WAL files before first use. on bool None
wal_recycle Write-Ahead Log / Settings Recycles WAL files by renaming them. on bool None

Removed Parameters

Category Description Default Value Var Type Enum Values history_url
name
default_with_oids Version and Platform Compatibility / Previous PostgreSQL Versions Create new tables with OIDs by default. off bool None
About this tool
© RustProof Labs, 2024
Maintained by RustProof Labs.