This is the multi-page printable view of this section. .
Related GUCs
- 1: [[guc:autovacuum_freeze_max_age]]
- 2: [[guc:autovacuum_multixact_freeze_max_age]]
- 3: [[guc:autovacuum_naptime]]
- 4: [[guc:checkpoint_timeout]]
- 5: [[guc:deadlock_timeout]]
- 6: [[guc:full_page_writes]]
- 7: [[guc:idle_in_transaction_session_timeout]]
- 8: [[guc:lock_timeout]]
- 9: [[guc:max_connections]]
- 10: [[guc:max_locks_per_transaction]]
- 11: [[guc:max_parallel_workers_per_gather]]
- 12: [[guc:max_wal_size]]
- 13: [[guc:shared_buffers]]
- 14: [[guc:synchronous_commit]]
- 15: [[guc:synchronous_standby_names]]
- 16: [[guc:vacuum_freeze_table_age]]
- 17: [[guc:vacuum_multixact_freeze_table_age]]
- 18: [[guc:wal_buffers]]
- 19: [[guc:wal_sender_timeout]]
- 20: [[guc:wal_writer_delay]]
- 21: [[guc:wal_writer_flush_after]]
Configuration controls referenced by wait-event response guidance. This index contains 21 entries.
1 - [[guc:autovacuum_freeze_max_age]]
Transaction age that forces anti-wraparound vacuum.
Official PostgreSQL 18 parameter reference
Referenced by wait events
2 - [[guc:autovacuum_multixact_freeze_max_age]]
Multixact age that forces anti-wraparound vacuum.
Official PostgreSQL 18 parameter reference
Referenced by wait events
3 - [[guc:autovacuum_naptime]]
Minimum delay between autovacuum launcher rounds per database.
Official PostgreSQL 18 parameter reference
Referenced by wait events
4 - [[guc:checkpoint_timeout]]
Maximum time between automatic WAL checkpoints.
Official PostgreSQL 18 parameter reference
Referenced by wait events
5 - [[guc:deadlock_timeout]]
Delay before PostgreSQL checks a lock wait for deadlock.
Official PostgreSQL 18 parameter reference
Referenced by wait events
6 - [[guc:full_page_writes]]
Controls full-page images after checkpoints for crash safety.
Official PostgreSQL 18 parameter reference
Referenced by wait events
7 - [[guc:idle_in_transaction_session_timeout]]
Terminates sessions left idle inside an open transaction.
Official PostgreSQL 18 parameter reference
Referenced by wait events
8 - [[guc:lock_timeout]]
Aborts statements that wait too long to acquire a lock.
Official PostgreSQL 18 parameter reference
Referenced by wait events
9 - [[guc:max_connections]]
Maximum concurrent database connections.
Official PostgreSQL 18 parameter reference
Referenced by wait events
10 - [[guc:max_locks_per_transaction]]
Shared lock-table capacity budget per transaction.
Official PostgreSQL 18 parameter reference
Referenced by wait events
11 - [[guc:max_parallel_workers_per_gather]]
Maximum parallel workers per Gather/Gather Merge node.
Official PostgreSQL 18 parameter reference
Referenced by wait events
12 - [[guc:max_wal_size]]
Soft WAL-volume limit that can trigger checkpoints.
Official PostgreSQL 18 parameter reference
Referenced by wait events
13 - [[guc:shared_buffers]]
Size of PostgreSQL’s shared buffer cache.
Official PostgreSQL 18 parameter reference
Referenced by wait events
14 - [[guc:synchronous_commit]]
Controls when commits wait for local or remote WAL durability.
Official PostgreSQL 18 parameter reference
Referenced by wait events
- Activity/RecoveryWalStream
- Activity/WalReceiverMain
- Activity/WalSenderMain
- Activity/WalSummarizerWal
- Activity/WalWriterMain
- Client/LibpqwalreceiverConnect
- Client/LibpqwalreceiverReceive
- Client/WalSenderWaitForWal
- Client/WalSenderWriteData
- IO/WalBootstrapSync
- IO/WalBootstrapWrite
- IO/WalCopyRead
- IO/WalCopySync
- IO/WalCopyWrite
- IO/WalInitSync
- IO/WalInitWrite
- IO/WalRead
- IO/WalSummaryRead
- IO/WalSummaryWrite
- IO/WalSync
- IO/WalSyncMethodAssign
- IO/WalWrite
- IO/WalsenderTimelineHistoryRead
- IPC/BackupWaitWalArchive
- IPC/WalReceiverExit
- IPC/WalReceiverUpstreamCatchup
- IPC/WalReceiverWaitStart
- IPC/WalSummaryReady
- LWLock/SyncRep
- LWLock/WALSummarizer
- LWLock/WALWrite
- Timeout/WalSummarizerError
15 - [[guc:synchronous_standby_names]]
Selects standbys that can satisfy synchronous commit.
Official PostgreSQL 18 parameter reference
Referenced by wait events
16 - [[guc:vacuum_freeze_table_age]]
Table age at which VACUUM scans for freezing.
Official PostgreSQL 18 parameter reference
Referenced by wait events
17 - [[guc:vacuum_multixact_freeze_table_age]]
Table multixact age at which VACUUM scans for freezing.
Official PostgreSQL 18 parameter reference
Referenced by wait events
18 - [[guc:wal_buffers]]
Shared-memory buffers used for WAL not yet written to disk.
Official PostgreSQL 18 parameter reference
Referenced by wait events
- Activity/RecoveryWalStream
- Activity/WalReceiverMain
- Activity/WalSenderMain
- Activity/WalSummarizerWal
- Activity/WalWriterMain
- Client/LibpqwalreceiverConnect
- Client/LibpqwalreceiverReceive
- Client/WalSenderWaitForWal
- Client/WalSenderWriteData
- IO/WalBootstrapSync
- IO/WalBootstrapWrite
- IO/WalCopyRead
- IO/WalCopySync
- IO/WalCopyWrite
- IO/WalInitSync
- IO/WalInitWrite
- IO/WalRead
- IO/WalSummaryRead
- IO/WalSummaryWrite
- IO/WalSync
- IO/WalSyncMethodAssign
- IO/WalWrite
- IO/WalsenderTimelineHistoryRead
- IPC/BackupWaitWalArchive
- IPC/WalReceiverExit
- IPC/WalReceiverUpstreamCatchup
- IPC/WalReceiverWaitStart
- IPC/WalSummaryReady
- LWLock/WALBufMapping
- LWLock/WALInsert
- LWLock/WALSummarizer
- Timeout/WalSummarizerError
19 - [[guc:wal_sender_timeout]]
Disconnects inactive replication connections after a timeout.
Official PostgreSQL 18 parameter reference
Referenced by wait events
20 - [[guc:wal_writer_delay]]
Delay between WAL writer activity rounds.
Official PostgreSQL 18 parameter reference
Referenced by wait events
21 - [[guc:wal_writer_flush_after]]
Amount of WAL written before the WAL writer requests a flush.
Official PostgreSQL 18 parameter reference