PostgreSQL Parameters (pg_settings)

 

How many configuration parameters in PostgreSQL 15 (beta2)?

With rollup function, there are total 353 parameter settings.

postgres=# select context,count(*) from pg_settings
postgres-# group by rollup(context)
postgres-# order by context nulls last;
      context      | count
-------------------+-------
 backend           |     2
 internal          |    20
 postmaster        |    55
 sighup            |    92
 superuser         |    44
 superuser-backend |     4
 user              |   136
                   |   353
(8 rows)

Configuration parameter for "context=backend"

You can check the setting without restarting the PostgreSQL instance, it only take effects for new sessions after parameter change, instead of existing sessions.

select name,setting,short_desc from pg_settings
where context='backend' order by name;

select '|'||name||'|'||setting||'|'||short_desc||'|' from pg_settings
where context='backend' order by name;

name	setting	setting
ignore_system_indexes	off	Disables reading from system indexes.
post_auth_delay	0	Sets the amount of time to wait after authentication on connection startup.

Configuration parameter for "context=internal"

These settings for information only, not for change directly. Some of them can be changed by "rebuilding" the PostgreSQL binary or passing options to initial initdb process.

select name,setting,short_desc from pg_settings
where context='internal' order by name;

select '|'||name||'|'||setting||'|'||short_desc||'|' from pg_settings
where context='internal' order by name;

name	setting	setting
block_size	8192	Shows the size of a disk block.
data_checksums	off	Shows whether data checksums are turned on for this cluster.
data_directory_mode	0700	Shows the mode of the data directory.
debug_assertions	on	Shows whether the running server has assertion checks enabled.
in_hot_standby	off	Shows whether hot standby is currently active.
integer_datetimes	on	Shows whether datetimes are integer based.
lc_collate	en_US.UTF-8	Shows the collation order locale.
lc_ctype	en_US.UTF-8	Shows the character classification and case conversion locale.
max_function_args	100	Shows the maximum number of function arguments.
max_identifier_length	63	Shows the maximum identifier length.
max_index_keys	32	Shows the maximum number of index keys.
segment_size	131072	Shows the number of pages per disk file.
server_encoding	UTF8	Shows the server (database) character set encoding.
server_version	15beta2	Shows the server version.
server_version_num	150000	Shows the server version as an integer.
shared_memory_size	143	Shows the size of the server's main shared memory area (rounded up to the nearest MB).
shared_memory_size_in_huge_pages	72	Shows the number of huge pages needed for the main shared memory area.
ssl_library	OpenSSL	Shows the name of the SSL library.
wal_block_size	8192	Shows the block size in the write ahead log.
wal_segment_size	16777216	Shows the size of write ahead log segments.

Configuration parameter for "context=postmaster"

These settings can only be applied during server startup, so any changes requires server restart (Downtime!!!).

select name,setting,short_desc from pg_settings
where context='postmaster' order by name;

select '|'||name||'|'||setting||'|'||short_desc||'|' from pg_settings
where context='postmaster' order by name;

name	setting	setting
archive_mode	off	Allows archiving of WAL files using archive_command.
autovacuum_freeze_max_age	200000000	Age at which to autovacuum a table to prevent transaction ID wraparound.
autovacuum_max_workers	3	Sets the maximum number of simultaneously running autovacuum worker processes.
autovacuum_multixact_freeze_max_age	400000000	Multixact age at which to autovacuum a table to prevent multixact wraparound.
bonjour	off	Enables advertising the server via Bonjour.
bonjour_name		Sets the Bonjour service name.
cluster_name		Sets the name of the cluster, which is included in the process title.
config_file	/var/lib/pgsql/15/data/postgresql.conf	Sets the server's main configuration file.
data_directory	/var/lib/pgsql/15/data	Sets the server's data directory.
data_sync_retry	off	Whether to continue running after a failure to sync data files.
dynamic_shared_memory_type	posix	Selects the dynamic shared memory implementation used.
event_source	PostgreSQL	Sets the application name used to identify PostgreSQL messages in the event log.
external_pid_file		Writes the postmaster PID to the specified file.
hba_file	/var/lib/pgsql/15/data/pg_hba.conf	Sets the server's "hba" configuration file.
hot_standby	on	Allows connections and queries during recovery.
huge_pages	try	Use of huge pages on Linux or Windows.
huge_page_size	0	The size of huge page that should be requested.
ident_file	/var/lib/pgsql/15/data/pg_ident.conf	Sets the server's "ident" configuration file.
ignore_invalid_pages	off	Continues recovery after an invalid pages failure.
jit_provider	llvmjit	JIT provider to use.
listen_addresses	localhost	Sets the host name or IP address(es) to listen to.
logging_collector	on	Start a subprocess to capture stderr output and/or csvlogs into log files.
max_connections	100	Sets the maximum number of concurrent connections.
max_files_per_process	1000	Sets the maximum number of simultaneously open files for each server process.
max_locks_per_transaction	64	Sets the maximum number of locks per transaction.
max_logical_replication_workers	4	Maximum number of logical replication worker processes.
max_pred_locks_per_transaction	64	Sets the maximum number of predicate locks per transaction.
max_prepared_transactions	0	Sets the maximum number of simultaneously prepared transactions.
max_replication_slots	10	Sets the maximum number of simultaneously defined replication slots.
max_wal_senders	10	Sets the maximum number of simultaneously running WAL sender processes.
max_worker_processes	8	Maximum number of concurrent worker processes.
min_dynamic_shared_memory	0	Amount of dynamic shared memory reserved at startup.
old_snapshot_threshold	-1	Time before a snapshot is too old to read pages changed after the snapshot was taken.
port	5432	Sets the TCP port the server listens on.
recovery_target		Set to "immediate" to end recovery as soon as a consistent state is reached.
recovery_target_action	pause	Sets the action to perform upon reaching the recovery target.
recovery_target_inclusive	on	Sets whether to include or exclude transaction with recovery target.
recovery_target_lsn		Sets the LSN of the write-ahead log location up to which recovery will proceed.
recovery_target_name		Sets the named restore point up to which recovery will proceed.
recovery_target_time		Sets the time stamp up to which recovery will proceed.
recovery_target_timeline	latest	Specifies the timeline to recover into.
recovery_target_xid		Sets the transaction ID up to which recovery will proceed.
shared_buffers	16384	Sets the number of shared memory buffers used by the server.
shared_memory_type	mmap	Selects the shared memory implementation used for the main shared memory region.
shared_preload_libraries		Lists shared libraries to preload into server.
superuser_reserved_connections	3	Sets the number of connection slots reserved for superusers.
track_activity_query_size	1024	Sets the size reserved for pg_stat_activity.query, in bytes.
track_commit_timestamp	off	Collects transaction commit time.
unix_socket_directories	/var/run/postgresql, /tmp	Sets the directories where Unix-domain sockets will be created.
unix_socket_group		Sets the owning group of the Unix-domain socket.
unix_socket_permissions	0777	Sets the access permissions of the Unix-domain socket.
wal_buffers	512	Sets the number of disk-page buffers in shared memory for WAL.
wal_decode_buffer_size	524288	Maximum buffer size for reading ahead in the WAL during recovery.
wal_level	replica	Sets the level of information written to the WAL.
wal_log_hints	off	Writes full pages to WAL when first modified after a checkpoint, even for a non-critical modification.

Configuration parameter for "context=sighup"

Changes to these settings can be made in postgresql.conf without restarting the server. Send a SIGHUP signal to the postmaster to cause it to re-read postgresql.conf and apply the changes. The postmaster will also forward the SIGHUP signal to its child processes so that they all pick up the new value.

select name,setting,short_desc from pg_settings
where context='sighup' order by name;

select '|'||name||'|'||setting||'|'||short_desc||'|' from pg_settings
where context='sighup' order by name;

name	setting	setting
archive_cleanup_command		Sets the shell command that will be executed at every restart point.
archive_command	(disabled)	Sets the shell command that will be called to archive a WAL file.
archive_library		Sets the library that will be called to archive a WAL file.
archive_timeout	0	Sets the amount of time to wait before forcing a switch to the next WAL file.
authentication_timeout	60	Sets the maximum allowed time to complete client authentication.
autovacuum	on	Starts the autovacuum subprocess.
autovacuum_analyze_scale_factor	0.1	Number of tuple inserts, updates, or deletes prior to analyze as a fraction of reltuples.
autovacuum_analyze_threshold	50	Minimum number of tuple inserts, updates, or deletes prior to analyze.
autovacuum_naptime	60	Time to sleep between autovacuum runs.
autovacuum_vacuum_cost_delay	2	Vacuum cost delay in milliseconds, for autovacuum.
autovacuum_vacuum_cost_limit	-1	Vacuum cost amount available before napping, for autovacuum.
autovacuum_vacuum_insert_scale_factor	0.2	Number of tuple inserts prior to vacuum as a fraction of reltuples.
autovacuum_vacuum_insert_threshold	1000	Minimum number of tuple inserts prior to vacuum, or -1 to disable insert vacuums.
autovacuum_vacuum_scale_factor	0.2	Number of tuple updates or deletes prior to vacuum as a fraction of reltuples.
autovacuum_vacuum_threshold	50	Minimum number of tuple updates or deletes prior to vacuum.
autovacuum_work_mem	-1	Sets the maximum memory to be used by each autovacuum worker process.
bgwriter_delay	200	Background writer sleep time between rounds.
bgwriter_flush_after	64	Number of pages after which previously performed writes are flushed to disk.
bgwriter_lru_maxpages	100	Background writer maximum number of LRU pages to flush per round.
bgwriter_lru_multiplier	2	Multiple of the average buffer usage to free per round.
checkpoint_completion_target	0.9	Time spent flushing dirty buffers during checkpoint, as fraction of checkpoint interval.
checkpoint_flush_after	32	Number of pages after which previously performed writes are flushed to disk.
checkpoint_timeout	300	Sets the maximum time between automatic WAL checkpoints.
checkpoint_warning	30	Sets the maximum time before warning if checkpoints triggered by WAL volume happen too frequently.
db_user_namespace	off	Enables per-database user names.
fsync	on	Forces synchronization of updates to disk.
full_page_writes	on	Writes full pages to WAL when first modified after a checkpoint.
hot_standby_feedback	off	Allows feedback from a hot standby to the primary that will avoid query conflicts.
krb_caseins_users	off	Sets whether Kerberos and GSSAPI user names should be treated as case-insensitive.
krb_server_keyfile	FILE:/etc/sysconfig/pgsql/krb5.keytab	Sets the location of the Kerberos server key file.
log_autovacuum_min_duration	600000	Sets the minimum execution time above which autovacuum actions will be logged.
log_checkpoints	on	Logs each checkpoint.
log_destination	stderr	Sets the destination for server log output.
log_directory	log	Sets the destination directory for log files.
log_file_mode	0600	Sets the file permissions for log files.
log_filename	postgresql-%a.log	Sets the file name pattern for log files.
log_hostname	off	Logs the host name in the connection logs.
log_line_prefix	%m [%p]	Controls information prefixed to each log line.
log_recovery_conflict_waits	off	Logs standby recovery conflict waits.
log_rotation_age	1440	Sets the amount of time to wait before forcing log file rotation.
log_rotation_size	0	Sets the maximum size a log file can reach before being rotated.
log_startup_progress_interval	10000	Time between progress updates for long-running startup operations.
log_timezone	UTC	Sets the time zone to use in log messages.
log_truncate_on_rotation	on	Truncate existing log files of same name during log rotation.
max_pred_locks_per_page	2	Sets the maximum number of predicate-locked tuples per page.
max_pred_locks_per_relation	-2	Sets the maximum number of predicate-locked pages and tuples per relation.
max_slot_wal_keep_size	-1	Sets the maximum WAL size that can be reserved by replication slots.
max_standby_archive_delay	30000	Sets the maximum delay before canceling queries when a hot standby server is processing archived WAL data.
max_standby_streaming_delay	30000	Sets the maximum delay before canceling queries when a hot standby server is processing streamed WAL data.
max_sync_workers_per_subscription	2	Maximum number of table synchronization workers per subscription.
max_wal_size	1024	Sets the WAL size that triggers a checkpoint.
min_wal_size	80	Sets the minimum size to shrink the WAL to.
pre_auth_delay	0	Sets the amount of time to wait before authentication on connection startup.
primary_conninfo		Sets the connection string to be used to connect to the sending server.
primary_slot_name		Sets the name of the replication slot to use on the sending server.
promote_trigger_file		Specifies a file name whose presence ends recovery in the standby.
recovery_end_command		Sets the shell command that will be executed once at the end of recovery.
recovery_init_sync_method	fsync	Sets the method for synchronizing the data directory before crash recovery.
recovery_min_apply_delay	0	Sets the minimum delay for applying changes during recovery.
recovery_prefetch	try	Prefetch referenced blocks during recovery
remove_temp_files_after_crash	on	Remove temporary files after backend crash.
restart_after_crash	on	Reinitialize server after backend crash.
restore_command		Sets the shell command that will be called to retrieve an archived WAL file.
ssl	off	Enables SSL connections.
ssl_ca_file		Location of the SSL certificate authority file.
ssl_cert_file	server.crt	Location of the SSL server certificate file.
ssl_ciphers	HIGH:MEDIUM:+3DES:!aNULL	Sets the list of allowed SSL ciphers.
ssl_crl_dir		Location of the SSL certificate revocation list directory.
ssl_crl_file		Location of the SSL certificate revocation list file.
ssl_dh_params_file		Location of the SSL DH parameters file.
ssl_ecdh_curve	prime256v1	Sets the curve to use for ECDH.
ssl_key_file	server.key	Location of the SSL server private key file.
ssl_max_protocol_version		Sets the maximum SSL/TLS protocol version to use.
ssl_min_protocol_version	TLSv1.2	Sets the minimum SSL/TLS protocol version to use.
ssl_passphrase_command		Command to obtain passphrases for SSL.
ssl_passphrase_command_supports_reload	off	Controls whether ssl_passphrase_command is called during server reload.
ssl_prefer_server_ciphers	on	Give priority to server ciphersuite order.
synchronous_standby_names		Number of synchronous standbys and list of names of potential synchronous ones.
syslog_facility	local0	Sets the syslog "facility" to be used when syslog enabled.
syslog_ident	postgres	Sets the program name used to identify PostgreSQL messages in syslog.
syslog_sequence_numbers	on	Add sequence number to syslog messages to avoid duplicate suppression.
syslog_split_messages	on	Split messages sent to syslog by lines and to fit into 1024 bytes.
trace_recovery_messages	log	Enables logging of recovery-related debugging information.
vacuum_defer_cleanup_age	0	Number of transactions by which VACUUM and HOT cleanup should be deferred, if any.
wal_keep_size	0	Sets the size of WAL files held for standby servers.
wal_receiver_create_temp_slot	off	Sets whether a WAL receiver should create a temporary replication slot if no permanent slot is configured.
wal_receiver_status_interval	10	Sets the maximum interval between WAL receiver status reports to the sending server.
wal_receiver_timeout	60000	Sets the maximum wait time to receive data from the sending server.
wal_retrieve_retry_interval	5000	Sets the time to wait before retrying to retrieve WAL after a failed attempt.
wal_sync_method	fdatasync	Selects the method used for forcing WAL updates to disk.
wal_writer_delay	200	Time between WAL flushes performed in the WAL writer.
wal_writer_flush_after	128	Amount of WAL written out by WAL writer that triggers a flush.

Configuration parameter for "context=superuser"

These settings can be set from postgresql.conf, or within a session via the SET command; but only superusers can change them via SET.

select name,setting,short_desc from pg_settings
where context='superuser' order by name;

select '|'||name||'|'||setting||'|'||short_desc||'|' from pg_settings
where context='superuser' order by name;

name	setting	setting
allow_in_place_tablespaces	off	Allows tablespaces directly inside pg_tblspc, for testing.
allow_system_table_mods	off	Allows modifications of the structure of system tables.
backtrace_functions		Log backtrace for errors in these functions.
commit_delay	0	Sets the delay in microseconds between transaction commit and flushing WAL to disk.
compute_query_id	auto	Enables in-core computation of query identifiers.
deadlock_timeout	1000	Sets the time to wait on a lock before checking for deadlock.
debug_discard_caches	0	Aggressively flush system caches for debugging purposes.
dynamic_library_path	$libdir	Sets the path for dynamically loadable modules.
ignore_checksum_failure	off	Continues processing after a checksum failure.
jit_dump_bitcode	off	Write out LLVM bitcode to facilitate JIT debugging.
lc_messages	en_US.UTF-8	Sets the language in which messages are displayed.
lo_compat_privileges	off	Enables backward compatibility mode for privilege checks on large objects.
log_duration	off	Logs the duration of each completed SQL statement.
log_error_verbosity	default	Sets the verbosity of logged messages.
log_executor_stats	off	Writes executor performance statistics to the server log.
log_lock_waits	off	Logs long lock waits.
log_min_duration_sample	-1	Sets the minimum execution time above which a sample of statements will be logged. Sampling is determined by log_statement_sample_rate.
log_min_duration_statement	-1	Sets the minimum execution time above which all statements will be logged.
log_min_error_statement	error	Causes all statements generating error at or above this level to be logged.
log_min_messages	warning	Sets the message levels that are logged.
log_parameter_max_length	-1	Sets the maximum length in bytes of data logged for bind parameter values when logging statements.
log_parser_stats	off	Writes parser performance statistics to the server log.
log_planner_stats	off	Writes planner performance statistics to the server log.
log_replication_commands	off	Logs each replication command.
log_statement	none	Sets the type of statements logged.
log_statement_sample_rate	1	Fraction of statements exceeding log_min_duration_sample to be logged.
log_statement_stats	off	Writes cumulative performance statistics to the server log.
log_temp_files	-1	Log the use of temporary files larger than this number of kilobytes.
log_transaction_sample_rate	0	Sets the fraction of transactions from which to log all statements.
max_stack_depth	2048	Sets the maximum stack depth, in kilobytes.
session_preload_libraries		Lists shared libraries to preload into each backend.
session_replication_role	origin	Sets the session's behavior for triggers and rewrite rules.
temp_file_limit	-1	Limits the total size of all temporary files used by each process.
track_activities	on	Collects information about executing commands.
track_counts	on	Collects statistics on database activity.
track_functions	none	Collects function-level statistics on database activity.
track_io_timing	off	Collects timing statistics for database I/O activity.
track_wal_io_timing	off	Collects timing statistics for WAL I/O activity.
update_process_title	on	Updates the process title to show the active SQL command.
wal_compression	off	Compresses full-page writes written in WAL file with specified method.
wal_consistency_checking		Sets the WAL resource managers for which WAL consistency checks are done.
wal_init_zero	on	Writes zeroes to new WAL files before first use.
wal_recycle	on	Recycles WAL files by renaming them.
zero_damaged_pages	off	Continues processing past damaged page headers.

Configuration parameter for "context=superuser-backend"

These values can be set without restarting PostgreSQL server, but only take effects on subsequently launched sessions.

select name,setting,short_desc from pg_settings
where context='superuser-backend' order by name;

select '|'||name||'|'||setting||'|'||short_desc||'|' from pg_settings
where context='superuser-backend' order by name;

name	setting	setting
jit_debugging_support	off	Register JIT-compiled functions with debugger.
jit_profiling_support	off	Register JIT-compiled functions with perf profiler.
log_connections	off	Logs each successful connection.
log_disconnections	off	Logs end of a session, including duration.

Configuration parameter for "context=user"

These settings can be set from postgresql.conf, or within a session via the SET command (higher precedence). Any user is allowed to change their session-local value.

select name,setting,short_desc from pg_settings
where context='user' order by name;

select '|'||name||'|'||setting||'|'||short_desc||'|' from pg_settings
where context='user' order by name;

name	setting	setting
application_name	psql	Sets the application name to be reported in statistics and logs.
array_nulls	on	Enable input of NULL elements in arrays.
backend_flush_after	0	Number of pages after which previously performed writes are flushed to disk.
backslash_quote	safe_encoding	Sets whether "'" is allowed in string literals.
bytea_output	hex	Sets the output format for bytea.
check_function_bodies	on	Check routine bodies during CREATE FUNCTION and CREATE PROCEDURE.
client_connection_check_interval	0	Sets the time interval between checks for disconnection while running queries.
client_encoding	UTF8	Sets the client's character set encoding.
client_min_messages	notice	Sets the message levels that are sent to the client.
commit_siblings	5	Sets the minimum number of concurrent open transactions required before performing commit_delay.
constraint_exclusion	partition	Enables the planner to use constraints to optimize queries.
cpu_index_tuple_cost	0.005	Sets the planner's estimate of the cost of processing each index entry during an index scan.
cpu_operator_cost	0.0025	Sets the planner's estimate of the cost of processing each operator or function call.
cpu_tuple_cost	0.01	Sets the planner's estimate of the cost of processing each tuple (row).
cursor_tuple_fraction	0.1	Sets the planner's estimate of the fraction of a cursor's rows that will be retrieved.
DateStyle	ISO, MDY	Sets the display format for date and time values.
debug_pretty_print	on	Indents parse and plan tree displays.
debug_print_parse	off	Logs each query's parse tree.
debug_print_plan	off	Logs each query's execution plan.
debug_print_rewritten	off	Logs each query's rewritten parse tree.
default_statistics_target	100	Sets the default statistics target.
default_table_access_method	heap	Sets the default table access method for new tables.
default_tablespace		Sets the default tablespace to create tables and indexes in.
default_text_search_config	pg_catalog.english	Sets default text search configuration.
default_toast_compression	pglz	Sets the default compression method for compressible values.
default_transaction_deferrable	off	Sets the default deferrable status of new transactions.
default_transaction_isolation	read committed	Sets the transaction isolation level of each new transaction.
default_transaction_read_only	off	Sets the default read-only status of new transactions.
effective_cache_size	524288	Sets the planner's assumption about the total size of the data caches.
effective_io_concurrency	1	Number of simultaneous requests that can be handled efficiently by the disk subsystem.
enable_async_append	on	Enables the planner's use of async append plans.
enable_bitmapscan	on	Enables the planner's use of bitmap-scan plans.
enable_gathermerge	on	Enables the planner's use of gather merge plans.
enable_group_by_reordering	on	enable reordering of GROUP BY key
enable_hashagg	on	Enables the planner's use of hashed aggregation plans.
enable_hashjoin	on	Enables the planner's use of hash join plans.
enable_incremental_sort	on	Enables the planner's use of incremental sort steps.
enable_indexonlyscan	on	Enables the planner's use of index-only-scan plans.
enable_indexscan	on	Enables the planner's use of index-scan plans.
enable_material	on	Enables the planner's use of materialization.
enable_memoize	on	Enables the planner's use of memoization.
enable_mergejoin	on	Enables the planner's use of merge join plans.
enable_nestloop	on	Enables the planner's use of nested-loop join plans.
enable_parallel_append	on	Enables the planner's use of parallel append plans.
enable_parallel_hash	on	Enables the planner's use of parallel hash plans.
enable_partition_pruning	on	Enables plan-time and execution-time partition pruning.
enable_partitionwise_aggregate	off	Enables partitionwise aggregation and grouping.
enable_partitionwise_join	off	Enables partitionwise join.
enable_seqscan	on	Enables the planner's use of sequential-scan plans.
enable_sort	on	Enables the planner's use of explicit sort steps.
enable_tidscan	on	Enables the planner's use of TID scan plans.
escape_string_warning	on	Warn about backslash escapes in ordinary string literals.
exit_on_error	off	Terminate session on any error.
extra_float_digits	1	Sets the number of digits displayed for floating-point values.
force_parallel_mode	off	Forces use of parallel query facilities.
from_collapse_limit	8	Sets the FROM-list size beyond which subqueries are not collapsed.
geqo	on	Enables genetic query optimization.
geqo_effort	5	GEQO: effort is used to set the default for other GEQO parameters.
geqo_generations	0	GEQO: number of iterations of the algorithm.
geqo_pool_size	0	GEQO: number of individuals in the population.
geqo_seed	0	GEQO: seed for random path selection.
geqo_selection_bias	2	GEQO: selective pressure within the population.
geqo_threshold	12	Sets the threshold of FROM items beyond which GEQO is used.
gin_fuzzy_search_limit	0	Sets the maximum allowed result for exact search by GIN.
gin_pending_list_limit	4096	Sets the maximum size of the pending list for GIN index.
hash_mem_multiplier	2	Multiple of work_mem to use for hash tables.
idle_in_transaction_session_timeout	0	Sets the maximum allowed idle time between queries, when in a transaction.
idle_session_timeout	0	Sets the maximum allowed idle time between queries, when not in a transaction.
IntervalStyle	postgres	Sets the display format for interval values.
jit	on	Allow JIT compilation.
jit_above_cost	100000	Perform JIT compilation if query is more expensive.
jit_expressions	on	Allow JIT compilation of expressions.
jit_inline_above_cost	500000	Perform JIT inlining if query is more expensive.
jit_optimize_above_cost	500000	Optimize JIT-compiled functions if query is more expensive.
jit_tuple_deforming	on	Allow JIT compilation of tuple deforming.
join_collapse_limit	8	Sets the FROM-list size beyond which JOIN constructs are not flattened.
lc_monetary	en_US.UTF-8	Sets the locale for formatting monetary amounts.
lc_numeric	en_US.UTF-8	Sets the locale for formatting numbers.
lc_time	en_US.UTF-8	Sets the locale for formatting date and time values.
local_preload_libraries		Lists unprivileged shared libraries to preload into each backend.
lock_timeout	0	Sets the maximum allowed duration of any wait for a lock.
logical_decoding_work_mem	65536	Sets the maximum memory to be used for logical decoding.
log_parameter_max_length_on_error	0	Sets the maximum length in bytes of data logged for bind parameter values when logging statements, on error.
maintenance_io_concurrency	10	A variant of effective_io_concurrency that is used for maintenance work.
maintenance_work_mem	65536	Sets the maximum memory to be used for maintenance operations.
max_parallel_maintenance_workers	2	Sets the maximum number of parallel processes per maintenance operation.
max_parallel_workers	8	Sets the maximum number of parallel workers that can be active at one time.
max_parallel_workers_per_gather	2	Sets the maximum number of parallel processes per executor node.
min_parallel_index_scan_size	64	Sets the minimum amount of index data for a parallel scan.
min_parallel_table_scan_size	1024	Sets the minimum amount of table data for a parallel scan.
parallel_leader_participation	on	Controls whether Gather and Gather Merge also run subplans.
parallel_setup_cost	1000	Sets the planner's estimate of the cost of starting up worker processes for parallel query.
parallel_tuple_cost	0.1	Sets the planner's estimate of the cost of passing each tuple (row) from worker to leader backend.
password_encryption	scram-sha-256	Chooses the algorithm for encrypting passwords.
plan_cache_mode	auto	Controls the planner's selection of custom or generic plan.
quote_all_identifiers	off	When generating SQL fragments, quote all identifiers.
random_page_cost	4	Sets the planner's estimate of the cost of a nonsequentially fetched disk page.
recursive_worktable_factor	10	Sets the planner's estimate of the average size of a recursive query's working table.
row_security	on	Enable row security.
search_path	"$user", public	Sets the schema search order for names that are not schema-qualified.
seq_page_cost	1	Sets the planner's estimate of the cost of a sequentially fetched disk page.
standard_conforming_strings	on	Causes '...' strings to treat backslashes literally.
statement_timeout	0	Sets the maximum allowed duration of any statement.
stats_fetch_consistency	cache	Sets the consistency of accesses to statistics data
synchronize_seqscans	on	Enable synchronized sequential scans.
synchronous_commit	on	Sets the current transaction's synchronization level.
tcp_keepalives_count	0	Maximum number of TCP keepalive retransmits.
tcp_keepalives_idle	0	Time between issuing TCP keepalives.
tcp_keepalives_interval	0	Time between TCP keepalive retransmits.
tcp_user_timeout	0	TCP user timeout.
temp_buffers	1024	Sets the maximum number of temporary buffers used by each session.
temp_tablespaces		Sets the tablespace(s) to use for temporary tables and sort files.
TimeZone	UTC	Sets the time zone for displaying and interpreting time stamps.
timezone_abbreviations	Default	Selects a file of time zone abbreviations.
trace_notify	off	Generates debugging output for LISTEN and NOTIFY.
trace_sort	off	Emit information about resource usage in sorting.
transaction_deferrable	off	Whether to defer a read-only serializable transaction until it can be executed with no possible serialization failures.
transaction_isolation	read committed	Sets the current transaction's isolation level.
transaction_read_only	off	Sets the current transaction's read-only status.
transform_null_equals	off	Treats "expr=NULL" as "expr IS NULL".
vacuum_cost_delay	0	Vacuum cost delay in milliseconds.
vacuum_cost_limit	200	Vacuum cost amount available before napping.
vacuum_cost_page_dirty	20	Vacuum cost for a page dirtied by vacuum.
vacuum_cost_page_hit	1	Vacuum cost for a page found in the buffer cache.
vacuum_cost_page_miss	2	Vacuum cost for a page not found in the buffer cache.
vacuum_failsafe_age	1600000000	Age at which VACUUM should trigger failsafe to avoid a wraparound outage.
vacuum_freeze_min_age	50000000	Minimum age at which VACUUM should freeze a table row.
vacuum_freeze_table_age	150000000	Age at which VACUUM should scan whole table to freeze tuples.
vacuum_multixact_failsafe_age	1600000000	Multixact age at which VACUUM should trigger failsafe to avoid a wraparound outage.
vacuum_multixact_freeze_min_age	5000000	Minimum age at which VACUUM should freeze a MultiXactId in a table row.
vacuum_multixact_freeze_table_age	150000000	Multixact age at which VACUUM should scan whole table to freeze tuples.
wal_sender_timeout	60000	Sets the maximum time to wait for WAL replication.
wal_skip_threshold	2048	Minimum size of new file to fsync instead of writing WAL.
work_mem	4096	Sets the maximum memory to be used for query workspaces.
xmlbinary	base64	Sets how binary values are to be encoded in XML.
xmloption	content	Sets whether XML data in implicit parsing and serialization operations is to be considered as documents or content fragments.

Reference:

• https://www.postgresql.org/docs/current/view-pg-settings.html