postgresql.conf comparison

Postgres Config Changes: 12 to 14

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 

New: 29

Updated: 9

Removed: 4

parameter 12 14 history
password_encryption md5 scram-sha-256
krb_server_keyfile '' 'FILE:${sysconfdir}/krb5.keytab'
vacuum_cost_page_miss 10 2
checkpoint_completion_target 0.5 0.9
wal_keep_segments 0 NaN
lc_messages 'en_US.UTF-8' 'C.UTF-8'
lc_monetary 'en_US.UTF-8' 'C.UTF-8'
lc_numeric 'en_US.UTF-8' 'C.UTF-8'
lc_time 'en_US.UTF-8' 'C.UTF-8'
operator_precedence_warning off NaN
force_parallel_mode off NaN
vacuum_cleanup_index_scale_factor 0.1 NaN
ssl_min_protocol_version 'TLSv1' 'TLSv1.2'
hash_mem_multiplier NaN 1.0
logical_decoding_work_mem NaN 64MB
maintenance_io_concurrency NaN 10
wal_skip_threshold NaN 2MB
wal_keep_size NaN 0
max_slot_wal_keep_size NaN -1
wal_receiver_create_temp_slot NaN off
enable_incremental_sort NaN on
log_min_duration_sample NaN -1
log_statement_sample_rate NaN 1.0
log_parameter_max_length NaN -1
log_parameter_max_length_on_error NaN 0
autovacuum_vacuum_insert_threshold NaN 1000
autovacuum_vacuum_insert_scale_factor NaN 0.2
client_connection_check_interval NaN 0
ssl_crl_dir NaN ''
huge_page_size NaN 0
min_dynamic_shared_memory NaN 0MB
enable_async_append NaN on
enable_gathermerge NaN on
enable_memoize NaN on
log_recovery_conflict_waits NaN off
track_wal_io_timing NaN off
compute_query_id NaN auto
default_toast_compression NaN 'pglz'
idle_session_timeout NaN 0
vacuum_failsafe_age NaN 1600000000
vacuum_multixact_failsafe_age NaN 1600000000
recovery_init_sync_method NaN fsync