Search PostgreSQL documentation

log_statement_statsConfigurationReferencelog_statement_stats Statistics 10 For each query, output performance statistics of the respective module to the server log. This is a crude profiling instrument, similar to the Unix getrusag…Configuration · Statistics log_temp_filesConfigurationReferencelog_temp_files Reporting and Logging 10 Controls logging of temporary file names and sizes. Temporary files can be created for sorts, hashes, and temporary query results. A log entry is made…Configuration · Reporting and Logging log_timezoneConfigurationReferencelog_timezone Reporting and Logging 10 Sets the time zone used for timestamps written in the server log. Unlike TimeZone, this value is cluster-wide, so that all sessions will report timestam…Configuration · Reporting and Logging log_transaction_sample_rateConfigurationReferencelog_transaction_sample_rate Reporting and Logging 12 Set the fraction of transactions whose statements are all logged, in addition to statements logged for other reasons. It applies to each …Configuration · Reporting and Logging log_truncate_on_rotationConfigurationReferencelog_truncate_on_rotation Reporting and Logging 10 When logging_collector is enabled, this parameter will cause PostgreSQL to truncate (overwrite), rather than append to, any existing log fil…Configuration · Reporting and Logging logging_collectorConfigurationReferencelogging_collector Reporting and Logging 10 This parameter enables the logging collector, which is a background process that captures log messages sent to stderr and redirects them into log f…Configuration · Reporting and Logging logical_decoding_work_memConfigurationReferencelogical_decoding_work_mem Resource Usage 13 Specifies the maximum amount of memory to be used by logical decoding, before some of the decoded changes are written to local disk. This limits t…Configuration · Resource Usage maintenance_io_concurrencyConfigurationReferencemaintenance_io_concurrency Resource Usage 13 Similar to effective_io_concurrency, but used for maintenance work that is done on behalf of many client sessions. The default is 10 on supported…Configuration · Resource Usage maintenance_work_memConfigurationReferencemaintenance_work_mem Resource Usage 10 Specifies the maximum amount of memory to be used by maintenance operations, such as VACUUM, CREATE INDEX, and ALTER TABLE ADD FOREIGN KEY. It defaults…Configuration · Resource Usage max_active_replication_originsConfigurationReferencemax_active_replication_origins Replication 18 Specifies how many replication origins (see Chapter 48) can be tracked simultaneously, effectively limiting how many logical replication subscri…Configuration · Replication max_connectionsConfigurationReferencemax_connections Connections and Authentication 10 Determines the maximum number of concurrent connections to the database server. The default is typically 100 connections, but might be less …Configuration · Connections and Authentication max_files_per_processConfigurationReferencemax_files_per_process Resource Usage 10 Sets the maximum number of simultaneously open files allowed to each server subprocess. The default is one thousand files. If the kernel is enforcing …Configuration · Resource Usage max_function_argsConfigurationReferencemax_function_args Preset Options 10 Reports the maximum number of function arguments. It is determined by the value of FUNC_MAX_ARGS when building the server. The default value is 100 argume…Configuration · Preset Options max_identifier_lengthConfigurationReferencemax_identifier_length Preset Options 10 Reports the maximum identifier length. It is determined as one less than the value of NAMEDATALEN when building the server. The default value of NAMED…Configuration · Preset Options max_index_keysConfigurationReferencemax_index_keys Preset Options 10 Reports the maximum number of index keys. It is determined by the value of INDEX_MAX_KEYS when building the server. The default value is 32 keys. 11 12 13 14…Configuration · Preset Options max_locks_per_transactionConfigurationReferencemax_locks_per_transaction Lock Management 10 The shared lock table tracks locks on max_locks_per_transaction * (max_connections + max_prepared_transactions) objects (e.g., tables); hence, no…Configuration · Lock Management max_logical_replication_workersConfigurationReferencemax_logical_replication_workers Replication 10 Specifies maximum number of logical replication workers. This includes both apply workers and table synchronization workers. Logical replicatio…Configuration · Replication max_notify_queue_pagesConfigurationReferencemax_notify_queue_pages Resource Usage 17 Specifies the maximum amount of allocated pages for NOTIFY / LISTEN queue. The default value is 1048576. For 8 KB pages it allows to consume up to 8 …Configuration · Resource Usage max_parallel_apply_workers_per_subscriptionConfigurationReferencemax_parallel_apply_workers_per_subscription Replication 16 Maximum number of parallel apply workers per subscription. This parameter controls the amount of parallelism for streaming of in-pr…Configuration · Replication max_parallel_maintenance_workersConfigurationReferencemax_parallel_maintenance_workers Resource Usage 11 Sets the maximum number of parallel workers that can be started by a single utility command. Currently, the only parallel utility command t…Configuration · Resource Usage max_parallel_workersConfigurationReferencemax_parallel_workers Resource Usage 10 Sets the maximum number of workers that the system can support for parallel queries. The default value is 8. When increasing or decreasing this value, …Configuration · Resource Usage max_parallel_workers_per_gatherConfigurationReferencemax_parallel_workers_per_gather Resource Usage 10 Sets the maximum number of workers that can be started by a single Gather or Gather Merge node. Parallel workers are taken from the pool of …Configuration · Resource Usage max_pred_locks_per_pageConfigurationReferencemax_pred_locks_per_page Lock Management 10 This controls how many rows on a single page can be predicate-locked before the lock is promoted to covering the whole page. The default is 2. This…Configuration · Lock Management max_pred_locks_per_relationConfigurationReferencemax_pred_locks_per_relation Lock Management 10 This controls how many pages or tuples of a single relation can be predicate-locked before the lock is promoted to covering the whole relation.…Configuration · Lock Management max_pred_locks_per_transactionConfigurationReferencemax_pred_locks_per_transaction Lock Management 10 The shared predicate lock table tracks locks on max_pred_locks_per_transaction * (max_connections + max_prepared_transactions) objects (e.g.…Configuration · Lock Management max_prepared_transactionsConfigurationReferencemax_prepared_transactions Resource Usage 10 Sets the maximum number of transactions that can be in the “prepared” state simultaneously (see PREPARE TRANSACTION). Setting this parameter to ze…Configuration · Resource Usage max_repack_replication_slotsConfigurationReferencemax_repack_replication_slots Replication 19 Specifies the maximum number of replication slots for use of the REPACK command. The default is 5. This parameter can only be set at server start.…Configuration · Replication max_replication_slotsConfigurationReferencemax_replication_slots Replication 10 Specifies the maximum number of replication slots (see Section 26.2.6) that the server can support. The default is 10. This parameter can only be set at …Configuration · Replication max_slot_wal_keep_sizeConfigurationReferencemax_slot_wal_keep_size Replication 13 Specify the maximum size of WAL files that replication slots are allowed to retain in the pg_wal directory at checkpoint time. If max_slot_wal_keep_size…Configuration · Replication max_stack_depthConfigurationReferencemax_stack_depth Resource Usage 10 Specifies the maximum safe depth of the server's execution stack. The ideal setting for this parameter is the actual stack size limit enforced by the kernel…Configuration · Resource Usage max_standby_archive_delayConfigurationReferencemax_standby_archive_delay Replication 10 When Hot Standby is active, this parameter determines how long the standby server should wait before canceling standby queries that conflict with abo…Configuration · Replication max_standby_streaming_delayConfigurationReferencemax_standby_streaming_delay Replication 10 When Hot Standby is active, this parameter determines how long the standby server should wait before canceling standby queries that conflict with a…Configuration · Replication max_sync_workers_per_subscriptionConfigurationReferencemax_sync_workers_per_subscription Replication 10 Maximum number of synchronization workers per subscription. This parameter controls the amount of parallelism of the initial data copy during…Configuration · Replication max_wal_sendersConfigurationReferencemax_wal_senders Replication 10 Specifies the maximum number of concurrent connections from standby servers or streaming base backup clients (i.e., the maximum number of simultaneously runnin…Configuration · Replication max_wal_sizeConfigurationReferencemax_wal_size Write-Ahead Log 10 Maximum size to let the WAL grow during automatic checkpoints. This is a soft limit; WAL size can exceed max_wal_size under special circumstances, like under …Configuration · Write-Ahead Log max_worker_processesConfigurationReferencemax_worker_processes Resource Usage 10 Sets the maximum number of background processes that the system can support. This parameter can only be set at server start. The default is 8. When run…Configuration · Resource Usage md5_password_warningsConfigurationReferencemd5_password_warnings Connections and Authentication 18 Controls whether a WARNING about MD5 password deprecation is produced when a CREATE ROLE or ALTER ROLE statement sets an MD5-encrypted…Configuration · Connections and Authentication min_dynamic_shared_memoryConfigurationReferencemin_dynamic_shared_memory Resource Usage 14 Specifies the amount of memory that should be allocated at server startup for use by parallel queries. When this memory region is insufficient or …Configuration · Resource Usage min_eager_agg_group_sizeConfigurationReferencemin_eager_agg_group_size Query Tuning 19 Sets the minimum average group size required to consider applying eager aggregation. This helps avoid the overhead of eager aggregation when it does …Configuration · Query Tuning min_parallel_index_scan_sizeConfigurationReferencemin_parallel_index_scan_size Query Tuning 10 Sets the minimum amount of index data that must be scanned in order for a parallel scan to be considered. Note that a parallel index scan typical…Configuration · Query Tuning