postgresql.conf comparison

Postgres Config Changes: 11 to 13

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

Removed: 2

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
autovacuum_vacuum_insert_scale_factor Autovacuum Number of tuple inserts prior to vacuum as a fraction of reltuples. 0.2 real None
autovacuum_vacuum_insert_threshold Autovacuum Minimum number of tuple inserts prior to vacuum, or -1 to disable insert vacuums. 1000 integer None
backtrace_functions Developer Options Log backtrace for errors in these functions. string None
default_table_access_method Client Connection Defaults / Statement Behavior Sets the default table access method for new tables. heap string None
enable_incremental_sort Query Tuning / Planner Method Configuration Enables the planner's use of incremental sort steps. on bool None
hash_mem_multiplier Resource Usage / Memory Multiple of work_mem to use for hash tables. 1 real None
ignore_invalid_pages Developer Options Continues recovery after an invalid pages failure. off bool None
log_min_duration_sample Reporting and Logging / When to Log Sets the minimum execution time above which a sample of statements will be logged. Sampling is determined by log_statement_sample_rate. -1 ms integer None
log_parameter_max_length Reporting and Logging / What to Log When logging statements, limit logged parameter values to first N bytes. -1 B integer None
log_parameter_max_length_on_error Reporting and Logging / What to Log When reporting an error, limit logged parameter values to first N bytes. 0 B integer None
log_statement_sample_rate Reporting and Logging / When to Log Fraction of statements exceeding log_min_duration_sample to be logged. 1 real None
log_transaction_sample_rate Reporting and Logging / When to Log Set the fraction of transactions to log for new transactions. 0 real None
logical_decoding_work_mem Resource Usage / Memory Sets the maximum memory to be used for logical decoding. 65536 kB integer None
maintenance_io_concurrency Resource Usage / Asynchronous Behavior A variant of effective_io_concurrency that is used for maintenance work. 10 integer None
max_slot_wal_keep_size Replication / Sending Servers Sets the maximum WAL size that can be reserved by replication slots. -1 MB integer None
pg_stat_statements.track_planning Customized Options Selects whether planning duration is tracked by pg_stat_statements. off bool 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 be called to 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.2 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_keep_size Replication / Sending Servers Sets the size of WAL files held for standby servers. 0 MB integer None
wal_receiver_create_temp_slot Replication / Standby Servers Sets whether a WAL receiver should create a temporary replication slot if no permanent slot is configured. off bool None
wal_recycle Write-Ahead Log / Settings Recycles WAL files by renaming them. on bool None
wal_skip_threshold Write-Ahead Log / Settings Size of new file to fsync instead of writing WAL. 2048 kB integer 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
wal_keep_segments Replication / Sending Servers Sets the number of WAL files held for standby servers. 0 integer None