Upgrade from: to: (just majors: ) matching:

Jump to:

Upgrading from 18.7 to 19 gives you 1.2 years worth of changes and fixes (200 of them)

⇑ Configuration changes:

⇑ Removed config parameters:

Config parameter: Default value:
escape_string_warning on
io_workers 3

⇑ Added config parameters:

Config parameter: Default value:
autovacuum_analyze_score_weight 1
autovacuum_freeze_score_weight 1
autovacuum_max_parallel_workers 0
autovacuum_multixact_freeze_score_weight 1
autovacuum_vacuum_insert_score_weight 1
autovacuum_vacuum_score_weight 1
debug_exec_backend off
debug_print_raw_parse off
effective_wal_level replica
enable_eager_aggregate on
hosts_file /pg/data/pg_hosts.conf
io_max_workers 8
io_min_workers 2
io_worker_idle_timeout 60000
io_worker_launch_interval 100
log_autoanalyze_min_duration 600000
max_repack_replication_slots 5
min_eager_agg_group_size 8
password_expiration_warning_threshold 604800
ssl_sni off
timing_clock_source auto (tsc)
wal_sender_shutdown_timeout -1

⇑ Config parameters with changed default value:

Config parameter: Default value in Pg 18.7: Default value in Pg 19:
jit on off
log_lock_waits off on
max_locks_per_transaction 64 128
shared_memory_size 150 153
shared_memory_size_in_huge_pages 75 77

List of changes: