select open change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

WAIT EVENTS / VERSION COMPARISON

What changed?

Wait Events · PostgreSQL 18 → 19 beta 3

Browse PG 19 →

Pre-release documentation. These definitions may change before the final release.

18 added · 2 removed · 1 changed · 0 coverage changes. These are changes in the pinned reference snapshots.

changedReplicationSlotsyncMain
--- 18
+++ 19 beta 3
@@ -1,2 +1,2 @@
 Activity/ReplicationSlotsyncMain
-Waiting in main loop of slot sync worker.
+Waiting in main loop of slot synchronization.
addedBufferCleanup
--- 18
+++ 19 beta 3
@@ -0,0 +1,2 @@
+Buffer/BufferCleanup
+Waiting to acquire an exclusive pin on a buffer. Buffer pin waits can be protracted if another process holds an open cursor that last read data from the buffer in question.
addedBufferExclusive
--- 18
+++ 19 beta 3
@@ -0,0 +1,2 @@
+Buffer/BufferExclusive
+Waiting to acquire a exclusive lock on a buffer.
removedBufferPin
--- 18
+++ 19 beta 3
@@ -1,2 +0,0 @@
-BufferPin/BufferPin
-Waiting to acquire an exclusive pin on a buffer.
addedBufferShared
--- 18
+++ 19 beta 3
@@ -0,0 +1,2 @@
+Buffer/BufferShared
+Waiting to acquire a shared lock on a buffer.
addedBufferShareExclusive
--- 18
+++ 19 beta 3
@@ -0,0 +1,2 @@
+Buffer/BufferShareExclusive
+Waiting to acquire a share exclusive lock on a buffer.
addedCopyFromRead
--- 18
+++ 19 beta 3
@@ -0,0 +1,2 @@
+IO/CopyFromRead
+Waiting to read data from a pipe, a file or a program during COPY FROM.
addedCopyToWrite
--- 18
+++ 19 beta 3
@@ -0,0 +1,2 @@
+IO/CopyToWrite
+Waiting to write data to a pipe, a file or a program during COPY TO.
addedChecksumEnableStartcondition
--- 18
+++ 19 beta 3
@@ -0,0 +1,2 @@
+IPC/ChecksumEnableStartcondition
+Waiting for data checksums enabling to start.
addedChecksumEnableTemptableWait
--- 18
+++ 19 beta 3
@@ -0,0 +1,2 @@
+IPC/ChecksumEnableTemptableWait
+Waiting for temporary tables to be dropped for data checksums to be enabled.
addedRepackWorkerExport
--- 18
+++ 19 beta 3
@@ -0,0 +1,2 @@
+IPC/RepackWorkerExport
+Waiting for decoding worker to export a new output file.
addedWaitForWalFlush
--- 18
+++ 19 beta 3
@@ -0,0 +1,2 @@
+IPC/WaitForWalFlush
+Waiting for WAL flush to reach a target LSN on a primary or standby.
addedWaitForWalReplay
--- 18
+++ 19 beta 3
@@ -0,0 +1,2 @@
+IPC/WaitForWalReplay
+Waiting for WAL replay to reach a target LSN on a standby.
addedWaitForWalWrite
--- 18
+++ 19 beta 3
@@ -0,0 +1,2 @@
+IPC/WaitForWalWrite
+Waiting for WAL write to reach a target LSN on a standby.
addedAioWorkerControl
--- 18
+++ 19 beta 3
@@ -0,0 +1,2 @@
+LWLock/AioWorkerControl
+Waiting to update AIO worker information.
removedBufferContent
--- 18
+++ 19 beta 3
@@ -1,2 +0,0 @@
-LWLock/BufferContent
-Waiting to access a data page in memory.
addedDataChecksumsWorker
--- 18
+++ 19 beta 3
@@ -0,0 +1,2 @@
+LWLock/DataChecksumsWorker
+Waiting for data checksums worker.
addedLogicalDecodingControl
--- 18
+++ 19 beta 3
@@ -0,0 +1,2 @@
+LWLock/LogicalDecodingControl
+Waiting to read or update logical decoding status information.
addedNotifyChannelHash
--- 18
+++ 19 beta 3
@@ -0,0 +1,2 @@
+LWLock/NotifyChannelHash
+Waiting to access the NOTIFY channel hash table.
addedWaitLSN
--- 18
+++ 19 beta 3
@@ -0,0 +1,2 @@
+LWLock/WaitLSN
+Waiting to read or update shared Wait-for-LSN state.
addedCommitDelay
--- 18
+++ 19 beta 3
@@ -0,0 +1,2 @@
+Timeout/CommitDelay
+Waiting for commit delay before WAL flush.