postgresql.conf comparison

Postgres Config Changes: 10 to 12

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: 5

New: 48

Removed: 2

Updated Parameters

Category Description Changed: history_url
name
autovacuum_vacuum_cost_delay Autovacuum Vacuum cost delay in milliseconds, for autovacuum. Default value: 20 -> 2, Variable type: integer -> real
extra_float_digits Client Connection Defaults / Locale and Formatting Sets the number of digits displayed for floating-point values. Default value: 0 -> 1
krb_server_keyfile Connections and Authentication / Authentication Sets the location of the Kerberos server key file. Default value: FILE:/usr/local/pgsql/etc/krb5.keytab -> FILE:/etc/postgresql-common/krb5.keytab
transaction_isolation Client Connection Defaults / Statement Behavior Sets the current transaction's isolation level. Default value: default -> read committed, Variable type: string -> enum
vacuum_cost_delay Resource Usage / Cost-Based Vacuum Delay Vacuum cost delay in milliseconds. Variable type: integer -> real

New Parameters

Category Description Default Value Var Type Enum Values history_url
name
archive_cleanup_command Write-Ahead Log / Archive Recovery Sets the shell command that will be executed at every restart point. string None
default_table_access_method Client Connection Defaults / Statement Behavior Sets the default table access method for new tables. heap string None
enable_parallel_append Query Tuning / Planner Method Configuration Enables the planner's use of parallel append plans. on bool None
enable_parallel_hash Query Tuning / Planner Method Configuration Enables the planner's use of parallel hash plans. on bool None
enable_partition_pruning Query Tuning / Planner Method Configuration Enables plan-time and run-time partition pruning. on bool None
enable_partitionwise_aggregate Query Tuning / Planner Method Configuration Enables partitionwise aggregation and grouping. off bool None
enable_partitionwise_join Query Tuning / Planner Method Configuration Enables partitionwise join. off bool None
jit Query Tuning / Other Planner Options Allow JIT compilation. on bool None
jit_above_cost Query Tuning / Planner Cost Constants Perform JIT compilation if query is more expensive. 100000 real None
jit_debugging_support Developer Options Register JIT compiled function with debugger. off bool None
jit_dump_bitcode Developer Options Write out LLVM bitcode to facilitate JIT debugging. off bool None
jit_expressions Developer Options Allow JIT compilation of expressions. on bool None
jit_inline_above_cost Query Tuning / Planner Cost Constants Perform JIT inlining if query is more expensive. 500000 real None
jit_optimize_above_cost Query Tuning / Planner Cost Constants Optimize JITed functions if query is more expensive. 500000 real None
jit_profiling_support Developer Options Register JIT compiled function with perf profiler. off bool None
jit_provider Client Connection Defaults / Shared Library Preloading JIT provider to use. llvmjit string None
jit_tuple_deforming Developer Options Allow JIT compilation of tuple deforming. on bool None
log_transaction_sample_rate Reporting and Logging / When to Log Set the fraction of transactions to log for new transactions. 0 real None
max_parallel_maintenance_workers Resource Usage / Asynchronous Behavior Sets the maximum number of parallel processes per maintenance operation. 2 integer None
parallel_leader_participation Resource Usage / Asynchronous Behavior Controls whether Gather and Gather Merge also run subplans. on bool None
pg_stat_statements.max Customized Options Sets the maximum number of statements tracked by pg_stat_statements. 5000 integer None
pg_stat_statements.save Customized Options Save pg_stat_statements statistics across server shutdowns. on bool None
pg_stat_statements.track Customized Options Selects which statements are tracked by pg_stat_statements. top enum [none, top, all]
pg_stat_statements.track_utility Customized Options Selects whether utility commands are tracked by pg_stat_statements. on bool None
plan_cache_mode Query Tuning / Other Planner Options Controls the planner's selection of custom or generic plan. auto enum [auto, force_generic_plan, force_custom_plan]
primary_conninfo Replication / Standby Servers Sets the connection string to be used to connect to the sending server. string None
primary_slot_name Replication / Standby Servers Sets the name of the replication slot to use on the sending server. string None
promote_trigger_file Replication / Standby Servers Specifies a file name whose presence ends recovery in the standby. string None
recovery_end_command Write-Ahead Log / Archive Recovery Sets the shell command that will be executed once at the end of recovery. string None
recovery_min_apply_delay Replication / Standby Servers Sets the minimum delay for applying changes during recovery. 0 ms integer None
recovery_target Write-Ahead Log / Recovery Target Set to "immediate" to end recovery as soon as a consistent state is reached. string None
recovery_target_action Write-Ahead Log / Recovery Target Sets the action to perform upon reaching the recovery target. pause enum [pause, promote, shutdown]
recovery_target_inclusive Write-Ahead Log / Recovery Target Sets whether to include or exclude transaction with recovery target. on bool None
recovery_target_lsn Write-Ahead Log / Recovery Target Sets the LSN of the write-ahead log location up to which recovery will proceed. string None
recovery_target_name Write-Ahead Log / Recovery Target Sets the named restore point up to which recovery will proceed. string None
recovery_target_time Write-Ahead Log / Recovery Target Sets the time stamp up to which recovery will proceed. string None
recovery_target_timeline Write-Ahead Log / Recovery Target Specifies the timeline to recover into. latest string None
recovery_target_xid Write-Ahead Log / Recovery Target Sets the transaction ID up to which recovery will proceed. string None
restore_command Write-Ahead Log / Archive Recovery Sets the shell command that will retrieve an archived WAL file. string None
shared_memory_type Resource Usage / Memory Selects the shared memory implementation used for the main shared memory region. mmap enum [sysv, mmap]
ssl_max_protocol_version Connections and Authentication / SSL Sets the maximum SSL/TLS protocol version to use. enum [, TLSv1, TLSv1.1, TLSv1.2, TLSv1.3]
ssl_min_protocol_version Connections and Authentication / SSL Sets the minimum SSL/TLS protocol version to use. TLSv1 enum [TLSv1, TLSv1.1, TLSv1.2, TLSv1.3]
ssl_passphrase_command Connections and Authentication / SSL Command to obtain passphrases for SSL. string None
ssl_passphrase_command_supports_reload Connections and Authentication / SSL Also use ssl_passphrase_command during server reload. off bool None
tcp_user_timeout Client Connection Defaults / Other Defaults TCP user timeout. 0 ms integer None
vacuum_cleanup_index_scale_factor Client Connection Defaults / Statement Behavior Number of tuple inserts prior to index cleanup as a fraction of reltuples. 0.1 real None
wal_init_zero Write-Ahead Log / Settings Writes zeroes to new WAL files before first use. on bool None
wal_recycle Write-Ahead Log / Settings Recycles WAL files by renaming them. on bool None

Removed Parameters

Category Description Default Value Var Type Enum Values history_url
name
default_with_oids Version and Platform Compatibility / Previous PostgreSQL Versions Create new tables with OIDs by default. off bool None
replacement_sort_tuples Resource Usage / Memory Sets the maximum number of tuples to be sorted using replacement selection. 150000 integer None
About this tool
© RustProof Labs, 2024
Maintained by RustProof Labs.