Skip to content

Instantly share code, notes, and snippets.

@rngadam

rngadam/gist:32668d9221e8c173ffce552060e862a3

Created June 13, 2023 12:12
Show Gist options
  • Save rngadam/32668d9221e8c173ffce552060e862a3 to your computer and use it in GitHub Desktop.
Save rngadam/32668d9221e8c173ffce552060e862a3 to your computer and use it in GitHub Desktop.
Download ZIP
Output from select name, setting, short_desc from pg_settings order by name
Raw
gistfile1.txt
|name |setting |short_desc |
|-------------------------------------|--------------------------------------------------------------|---------------------------------------------------------------------------------------------------------------------------------------|
|DateStyle |ISO, MDY |Sets the display format for date and time values. |
|IntervalStyle |postgres |Sets the display format for interval values. |
|TimeZone |America/Toronto |Sets the time zone for displaying and interpreting time stamps. |
|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. |
|application_name |DBeaver 23.0.5 - SQLEditor <Script-3.sql> |Sets the application name to be reported in statistics and logs. |
|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_mode |off |Allows archiving of WAL files using archive_command. |
|archive_timeout |0 |Sets the amount of time to wait before forcing a switch to the next WAL file. |
|array_nulls |on |Enable input of NULL elements in arrays. |
|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_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. |
|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. |
|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. |
|backtrace_functions | |Log backtrace for errors in these functions. |
|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. |
|block_size |8192 |Shows the size of a disk block. |
|bonjour |off |Enables advertising the server via Bonjour. |
|bonjour_name | |Sets the Bonjour service name. |
|bytea_output |hex |Sets the output format for bytea. |
|check_function_bodies |on |Check routine bodies during CREATE FUNCTION and CREATE PROCEDURE. |
|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. |
|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. |
|cluster_name | |Sets the name of the cluster, which is included in the process title. |
|commit_delay |0 |Sets the delay in microseconds between transaction commit and flushing WAL to disk. |
|commit_siblings |5 |Sets the minimum number of concurrent open transactions required before performing commit_delay. |
|compute_query_id |auto |Enables in-core computation of query identifiers. |
|config_file |/home/vscode/.asdf/installs/postgres/15.3/data/postgresql.conf|Sets the server's main configuration file. |
|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. |
|data_checksums |off |Shows whether data checksums are turned on for this cluster. |
|data_directory |/home/vscode/.asdf/installs/postgres/15.3/data |Sets the server's data directory. |
|data_directory_mode |0700 |Shows the mode of the data directory. |
|data_sync_retry |off |Whether to continue running after a failure to sync data files. |
|db_user_namespace |off |Enables per-database user names. |
|deadlock_timeout |1000 |Sets the time to wait on a lock before checking for deadlock. |
|debug_assertions |off |Shows whether the running server has assertion checks enabled. |
|debug_discard_caches |0 |Aggressively flush system caches for debugging purposes. |
|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. |
|dynamic_library_path |$libdir |Sets the path for dynamically loadable modules. |
|dynamic_shared_memory_type |posix |Selects the dynamic shared memory implementation used. |
|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_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. |
|event_source |PostgreSQL |Sets the application name used to identify PostgreSQL messages in the event log. |
|exit_on_error |off |Terminate session on any error. |
|external_pid_file | |Writes the postmaster PID to the specified file. |
|extra_float_digits |3 |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. |
|fsync |on |Forces synchronization of updates to disk. |
|full_page_writes |on |Writes full pages to WAL when first modified after a checkpoint. |
|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. |
|hba_file |/home/vscode/.asdf/installs/postgres/15.3/data/pg_hba.conf |Sets the server's "hba" configuration file. |
|hot_standby |on |Allows connections and queries during recovery. |
|hot_standby_feedback |off |Allows feedback from a hot standby to the primary that will avoid query conflicts. |
|huge_page_size |0 |The size of huge page that should be requested. |
|huge_pages |try |Use of huge pages on Linux or Windows. |
|ident_file |/home/vscode/.asdf/installs/postgres/15.3/data/pg_ident.conf |Sets the server's "ident" configuration file. |
|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. |
|ignore_checksum_failure |off |Continues processing after a checksum failure. |
|ignore_invalid_pages |off |Continues recovery after an invalid pages failure. |
|ignore_system_indexes |off |Disables reading from system indexes. |
|in_hot_standby |off |Shows whether hot standby is currently active. |
|integer_datetimes |on |Shows whether datetimes are integer based. |
|jit |on |Allow JIT compilation. |
|jit_above_cost |100000 |Perform JIT compilation if query is more expensive. |
|jit_debugging_support |off |Register JIT-compiled functions with debugger. |
|jit_dump_bitcode |off |Write out LLVM bitcode to facilitate JIT debugging. |
|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_profiling_support |off |Register JIT-compiled functions with perf profiler. |
|jit_provider |llvmjit |JIT provider to use. |
|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. |
|krb_caseins_users |off |Sets whether Kerberos and GSSAPI user names should be treated as case-insensitive. |
|krb_server_keyfile | |Sets the location of the Kerberos server key file. |
|lc_collate |C |Shows the collation order locale. |
|lc_ctype |C |Shows the character classification and case conversion locale. |
|lc_messages |C |Sets the language in which messages are displayed. |
|lc_monetary |C |Sets the locale for formatting monetary amounts. |
|lc_numeric |C |Sets the locale for formatting numbers. |
|lc_time |C |Sets the locale for formatting date and time values. |
|listen_addresses |localhost |Sets the host name or IP address(es) to listen to. |
|lo_compat_privileges |off |Enables backward compatibility mode for privilege checks on large objects. |
|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. |
|log_autovacuum_min_duration |600000 |Sets the minimum execution time above which autovacuum actions will be logged. |
|log_checkpoints |on |Logs each checkpoint. |
|log_connections |off |Logs each successful connection. |
|log_destination |stderr |Sets the destination for server log output. |
|log_directory |log |Sets the destination directory for log files. |
|log_disconnections |off |Logs end of a session, including duration. |
|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_file_mode |0600 |Sets the file permissions for log files. |
|log_filename |postgresql-%Y-%m-%d_%H%M%S.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_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_parameter_max_length_on_error |0 |Sets the maximum length in bytes of data logged for bind parameter values when logging statements, on error. |
|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_recovery_conflict_waits |off |Logs standby recovery conflict waits. |
|log_replication_commands |off |Logs each replication command. |
|log_rotation_age |1440 |Sets the amount of time to wait before forcing log file rotation. |
|log_rotation_size |10240 |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_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_timezone |Etc/UTC |Sets the time zone to use in log messages. |
|log_transaction_sample_rate |0 |Sets the fraction of transactions from which to log all statements. |
|log_truncate_on_rotation |off |Truncate existing log files of same name during log rotation. |
|logging_collector |off |Start a subprocess to capture stderr output and/or csvlogs into log files. |
|logical_decoding_work_mem |65536 |Sets the maximum memory to be used for logical decoding. |
|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_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_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. |
|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_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. |
|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_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_slot_wal_keep_size |-1 |Sets the maximum WAL size that can be reserved by replication slots. |
|max_stack_depth |2048 |Sets the maximum stack depth, in kilobytes. |
|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_senders |10 |Sets the maximum number of simultaneously running WAL sender processes. |
|max_wal_size |1024 |Sets the WAL size that triggers a checkpoint. |
|max_worker_processes |8 |Maximum number of concurrent worker processes. |
|min_dynamic_shared_memory |0 |Amount of dynamic shared memory reserved at startup. |
|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. |
|min_wal_size |80 |Sets the minimum size to shrink the WAL to. |
|old_snapshot_threshold |-1 |Time before a snapshot is too old to read pages changed after the snapshot was taken. |
|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. |
|port |5432 |Sets the TCP port the server listens on. |
|post_auth_delay |0 |Sets the amount of time to wait after authentication on connection startup. |
|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. |
|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. |
|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. |
|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. |
|recursive_worktable_factor |10 |Sets the planner's estimate of the average size of a recursive query's working table. |
|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. |
|row_security |on |Enable row security. |
|search_path |public, public, "$user" |Sets the schema search order for names that are not schema-qualified. |
|segment_size |131072 |Shows the number of pages per disk file. |
|seq_page_cost |1 |Sets the planner's estimate of the cost of a sequentially fetched disk page. |
|server_encoding |UTF8 |Shows the server (database) character set encoding. |
|server_version |15.3 |Shows the server version. |
|server_version_num |150003 |Shows the server version as an integer. |
|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. |
|shared_buffers |16384 |Sets the number of shared memory buffers used by the server. |
|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. |
|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. |
|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_library |OpenSSL |Shows the name of the SSL library. |
|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. |
|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. |
|superuser_reserved_connections |3 |Sets the number of connection slots reserved for superusers. |
|synchronize_seqscans |on |Enable synchronized sequential scans. |
|synchronous_commit |on |Sets the current transaction's synchronization level. |
|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. |
|tcp_keepalives_count |9 |Maximum number of TCP keepalive retransmits. |
|tcp_keepalives_idle |7200 |Time between issuing TCP keepalives. |
|tcp_keepalives_interval |75 |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_file_limit |-1 |Limits the total size of all temporary files used by each process. |
|temp_tablespaces | |Sets the tablespace(s) to use for temporary tables and sort files. |
|timezone_abbreviations |Default |Selects a file of time zone abbreviations. |
|trace_notify |off |Generates debugging output for LISTEN and NOTIFY. |
|trace_recovery_messages |log |Enables logging of recovery-related debugging information. |
|trace_sort |off |Emit information about resource usage in sorting. |
|track_activities |on |Collects information about executing commands. |
|track_activity_query_size |1024 |Sets the size reserved for pg_stat_activity.query, in bytes. |
|track_commit_timestamp |off |Collects transaction commit time. |
|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. |
|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". |
|unix_socket_directories |/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. |
|update_process_title |on |Updates the process title to show the active SQL command. |
|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_defer_cleanup_age |0 |Number of transactions by which VACUUM and HOT cleanup should be deferred, if any. |
|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_block_size |8192 |Shows the block size in the write ahead log. |
|wal_buffers |512 |Sets the number of disk-page buffers in shared memory for WAL. |
|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_decode_buffer_size |524288 |Buffer size for reading ahead in the WAL during recovery. |
|wal_init_zero |on |Writes zeroes to new WAL files before first use. |
|wal_keep_size |0 |Sets the size of WAL files held for standby servers. |
|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. |
|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_recycle |on |Recycles WAL files by renaming them. |
|wal_retrieve_retry_interval |5000 |Sets the time to wait before retrying to retrieve WAL after a failed attempt. |
|wal_segment_size |16777216 |Shows the size of write ahead log segments. |
|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. |
|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. |
|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. |
|zero_damaged_pages |off |Continues processing past damaged page headers. |
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment