postgresql.conf comparison

Postgres Config Changes: 12 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: 1

New: 17

Removed: 1

Updated Parameters

Category Description Changed: history_url
name
ssl_min_protocol_version Connections and Authentication / SSL Sets the minimum SSL/TLS protocol version to use. Default value: TLSv1 -> TLSv1.2

New Parameters

Category Description Default Value Var Type Enum Values history_url
name
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
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
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
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_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
wal_keep_segments Replication / Sending Servers Sets the number of WAL files held for standby servers. 0 integer None