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