Upgrade from: to: matching:

Jump to:

Upgrading from 9.4 to 11.5 gives you 4.6 years worth of fixes (1733 of them)

Security fixes:

Configuration changes:

Removed config parameters:

Config parameter: Default value:
checkpoint_segments 3
sql_inheritance on
ssl_renegotiation_limit 524288

Added config parameters:

Config parameter: Default value:
backend_flush_after 0
bgwriter_flush_after 64
checkpoint_flush_after 32
cluster_name
data_directory_mode 0700
data_sync_retry off
enable_gathermerge on
enable_parallel_append on
enable_parallel_hash on
enable_partition_pruning on
enable_partitionwise_aggregate off
enable_partitionwise_join off
force_parallel_mode off
gin_pending_list_limit 4096
idle_in_transaction_session_timeout 0
jit off
jit_above_cost 100000
jit_debugging_support off
jit_dump_bitcode off
jit_expressions on
jit_inline_above_cost 500000
jit_optimize_above_cost 500000
jit_profiling_support off
jit_provider llvmjit
jit_tuple_deforming on
log_replication_commands off
max_logical_replication_workers 4
max_parallel_maintenance_workers 2
max_parallel_workers 8
max_parallel_workers_per_gather 2
max_pred_locks_per_page 2
max_pred_locks_per_relation -2
max_sync_workers_per_subscription 2
max_wal_size 1024
min_parallel_index_scan_size 64
min_parallel_table_scan_size 1024
min_wal_size 80
old_snapshot_threshold -1
operator_precedence_warning off
parallel_leader_participation on
parallel_setup_cost 1000
parallel_tuple_cost 0.1
row_security on
ssl_dh_params_file
ssl_passphrase_command
ssl_passphrase_command_supports_reload off
syslog_sequence_numbers on
syslog_split_messages on
track_commit_timestamp off
vacuum_cleanup_index_scale_factor 0.1
wal_compression off
wal_consistency_checking
wal_retrieve_retry_interval 5000
wal_writer_flush_after 128

Config parameters with changed default value:

Config parameter: Default value in Pg 9.4: Default value in Pg 11.5:
hot_standby off on
log_directory pg_log log
log_line_prefix %m [%p]
max_replication_slots 0 10
max_wal_senders 0 10
password_encryption on md5
search_path "$user",public "$user", public
wal_level minimal replica
wal_segment_size 2048 16777216

List of changes: