Waiting for LSN replay with WAIT FOR command

Edit
ID 5550
Title Waiting for LSN replay with WAIT FOR command
CI (CFBot) Needs rebase! Needs rebase since 10 months. Failing since 10 months.
Additional links previous successfully applied patch (outdated):
Summary
Stats (from CFBot) Unknown
Tags
Created 2025-02-06 07:40:33
Last modified 2025-11-15 23:31:56 (10 months ago)
Latest email 2026-09-13 09:57:18 (1 week ago)
Status
PG19-3 (2025-11-01 – 2025-11-30): Committed
PG19-2 (2025-09-01 – 2025-09-30): Moved to different CF
2025-03 (2025-03-01 – 2025-04-08): Moved to different CF
Target version
Authors Alexander Korotkov (smagen), Xuneng Zhou (egoa)
Reviewers Yura Sokolov (funny_falcon) Become reviewer
Committer Alexander Korotkov (smagen)
Links
Emails
Implement waiting for wal lsn replay: reloaded
First at 2024-11-27 04:08:51 by Alexander Korotkov <aekorotkov at gmail.com>
Latest at 2026-09-13 09:57:18 by Xuneng Zhou <xunengzhou at gmail.com>
Latest attachment (v3-0001-Prevent-WAIT-FOR-LSN-from-deadlocking-recovery-on.patch) at 2026-09-11 03:32:23 from Xuneng Zhou <xunengzhou at gmail.com>
    Attachment (v3-0001-Prevent-WAIT-FOR-LSN-from-deadlocking-recovery-on.patch) at 2026-09-11 03:32:23 from Xuneng Zhou <xunengzhou at gmail.com> (Patch: No)
    Attachment (v3-0001-Prevent-WAIT-FOR-LSN-from-deadlocking-recovery-on.patch) at 2026-09-09 05:39:28 from Xuneng Zhou <xunengzhou at gmail.com> (Patch: No)
    Attachment (v3-0001-Prevent-WAIT-FOR-LSN-from-deadlocking-recovery-on.patch) at 2026-09-09 03:38:21 from Xuneng Zhou <xunengzhou at gmail.com> (Patch: No)
    Attachment (v2-0001-Prevent-WAIT-FOR-LSN-from-deadlocking-recovery.patch) at 2026-09-07 11:28:38 from Alexander Korotkov <aekorotkov at gmail.com> (Patch: No)
    Attachment (archive_repro.sh) at 2026-09-06 09:11:18 from Xuneng Zhou <xunengzhou at gmail.com> (Patch: No)
    Attachment (v2-0001-Prevent-WAIT-FOR-LSN-from-deadlocking-recovery.patch) at 2026-09-06 02:35:56 from Xuneng Zhou <xunengzhou at gmail.com> (Patch: No)
    Attachment (v1-0001-Prevent-WAIT-FOR-LSN-from-deadlocking-standby-rep.patch) at 2026-08-26 05:31:54 from Xuneng Zhou <xunengzhou at gmail.com> (Patch: No)
    Attachment (v8-0001-Add-wait-for-lsn-process-exit-cleanup-callback.patch) at 2026-08-17 10:23:43 from Alexander Korotkov <aekorotkov at gmail.com> (Patch: No)
    Attachment (v7-0003-Avoid-locking-when-an-LSN-waiter-is-already-remov.patch) at 2026-08-15 00:01:17 from Alexander Korotkov <aekorotkov at gmail.com> (Patch: No)
    Attachment (v6-0002-Fix-WAIT-FOR-LSN-documentation-examples.patch) at 2026-07-31 11:22:59 from Xuneng Zhou <xunengzhou at gmail.com> (Patch: No)
    Attachment (v5-0001-Add-wait-for-lsn-process-exit-cleanup-callback.patch) at 2026-07-31 05:02:12 from Xuneng Zhou <xunengzhou at gmail.com> (Patch: No)
    Attachment (v4-0004-Clarify-LSN-waiter-cleanup-after-wakeup.patch) at 2026-07-31 03:39:11 from Xuneng Zhou <xunengzhou at gmail.com> (Patch: No)
    Attachment (v3-0005-Re-register-LSN-waiters-after-stale-wakeups.patch) at 2026-07-31 01:46:46 from Xuneng Zhou <xunengzhou at gmail.com> (Patch: No)
    Attachment (v2-0001-Add-wait-for-lsn-process-exit-cleanup-callback.patch) at 2026-07-31 00:58:53 from Xuneng Zhou <xunengzhou at gmail.com> (Patch: No)
    Attachment (v1-0005-Re-register-LSN-waiters-after-stale-wakeups.patch) at 2026-07-27 11:03:05 from Xuneng Zhou <xunengzhou at gmail.com> (Patch: No)
    Attachment (v1-0001-Add-wait-for-lsn-process-exit-cleanup-callback.patch) at 2026-07-09 12:24:57 from Xuneng Zhou <xunengzhou at gmail.com> (Patch: Yes)
    Attachment (v3-0001-Stabilize-019_replslot_limit.pl-after-wait_for_ca.patch) at 2026-05-26 15:53:14 from Xuneng Zhou <xunengzhou at gmail.com> (Patch: Yes)
    Attachment (v2-0002-Clean-up-replslot-limit-test-comments.patch) at 2026-05-26 01:48:26 from Xuneng Zhou <xunengzhou at gmail.com> (Patch: Yes)
    Attachment (v2-0001-Stabilize-019_replslot_limit.pl-after-wait_for_ca.patch) at 2026-05-20 12:16:45 from Alexander Korotkov <aekorotkov at gmail.com> (Patch: Yes)
    Attachment (0001-Stabilize-replslot-limit-test-after-standby-catchup.patch) at 2026-05-20 05:18:07 from Xuneng Zhou <xunengzhou at gmail.com> (Patch: Yes)
    Attachment (v8-0004-Use-replay-position-as-floor-for-WAIT-FOR-LSN-sta.patch) at 2026-05-01 02:44:00 from Xuneng Zhou <xunengzhou at gmail.com> (Patch: Yes)
    Attachment (v7-0002-Fix-memory-ordering-in-WAIT-FOR-LSN-wakeup-mechan.patch) at 2026-04-28 21:01:32 from Alexander Korotkov <aekorotkov at gmail.com> (Patch: Yes)
    Attachment (v5-0003-Remove-redundant-WAIT-FOR-LSN-caller-side-pre-che.patch) at 2026-04-21 04:03:30 from Xuneng Zhou <xunengzhou at gmail.com> (Patch: Yes)
    Attachment (v5-0001-Use-barrier-semantics-when-reading-writing-writte.patch) at 2026-04-20 18:45:51 from Alexander Korotkov <aekorotkov at gmail.com> (Patch: Yes)
    Attachment (v4-0001-Use-barrier-semantics-when-reading-writing-writte.patch) at 2026-04-10 06:13:05 from Xuneng Zhou <xunengzhou at gmail.com> (Patch: Yes)
    Attachment (v4-0001-Use-barrier-semantics-when-reading-writing-writte.patch) at 2026-04-10 03:59:22 from Xuneng Zhou <xunengzhou at gmail.com> (Patch: Yes)
    Attachment (v3-0002-Fix-memory-ordering-in-WAIT-FOR-LSN-wakeup-mechan.patch) at 2026-04-09 15:21:24 from Alexander Korotkov <aekorotkov at gmail.com> (Patch: Yes)
    Attachment (v1-0003-Wake-standby_write-standby_flush-waiters-from-the.patch) at 2026-04-08 04:59:03 from Xuneng Zhou <xunengzhou at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Remove-redundant-WAIT-FOR-LSN-caller-side-pre-che.patch) at 2026-04-08 03:23:54 from Xuneng Zhou <xunengzhou at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Fix-memory-ordering-in-WAIT-FOR-LSN-wakeup-mechan.patch) at 2026-04-07 15:55:43 from Xuneng Zhou <xunengzhou at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Minimal-fix-for-WAIT-FOR-.-MODE-standby_flush.patch) at 2026-04-07 13:18:37 from Andres Freund <andres at anarazel.de> (Patch: Yes)
    Attachment (v1-0001-Remove-redundant-WAIT-FOR-LSN-caller-side-pre-che.patch) at 2026-04-07 12:59:58 from Xuneng Zhou <xunengzhou at gmail.com> (Patch: Yes)
    Attachment (v4-0001-Avoid-syscache-lookup-while-building-a-WAIT-FOR-t.patch) at 2026-04-06 07:15:15 from Xuneng Zhou <xunengzhou at gmail.com> (Patch: Yes)
    Attachment (v3-0001-Avoid-syscache-lookup-while-building-a-WAIT-FOR-t.patch) at 2026-04-05 12:31:46 from Alexander Korotkov <aekorotkov at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Wake-LSN-waiters-before-recovery-target-stop.patch) at 2026-01-27 01:14:43 from Xuneng Zhou <xunengzhou at gmail.com> (Patch: Yes)
    Attachment (v1-0001-WAIT-FOR-Remove-redundant-pg_unreachable-after-el.patch) at 2026-01-20 01:28:31 from Xuneng Zhou <xunengzhou at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Avoid-syscache-lookup-in-WAIT-FOR-LSN-tuple-descr.patch) at 2026-01-12 06:53:46 from Xuneng Zhou <xunengzhou at gmail.com> (Patch: Yes)
    Attachment (v2-0001-Use-WAIT-FOR-LSN-in-PostgreSQL-Test-Cluster-wait_.patch) at 2026-01-10 04:47:13 from Xuneng Zhou <xunengzhou at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Use-WAIT-FOR-LSN-in-PostgreSQL-Test-Cluster-wait_.patch) at 2026-01-09 13:44:17 from Xuneng Zhou <xunengzhou at gmail.com> (Patch: Yes)
    Attachment (v1-0001-reproduce-the-failure-in-031_recovery_conflict.pl.patch) at 2026-01-07 04:08:18 from Xuneng Zhou <xunengzhou at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Move-snapshot-release-to-the-beginning-of-ExecWai.patch) at 2026-01-06 17:04:06 from Xuneng Zhou <xunengzhou at gmail.com> (Patch: Yes)
    Attachment (v2-0001-Fix-wait_for_catchup-failure-when-standby-session.patch) at 2026-01-06 15:53:11 from Xuneng Zhou <xunengzhou at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Fix-wait_for_catchup-failure-when-standby-session.patch) at 2026-01-06 13:12:41 from Xuneng Zhou <xunengzhou at gmail.com> (Patch: Yes)
    Attachment (v13-0001-Extend-xlogwait-infrastructure-with-write-and-fl.patch) at 2026-01-02 22:53:56 from Alexander Korotkov <aekorotkov at gmail.com> (Patch: Yes)
    Attachment (v12-0003-Add-tab-completion-for-WAIT-FOR-LSN-MODE-option.patch) at 2026-01-02 09:17:34 from Xuneng Zhou <xunengzhou at gmail.com> (Patch: Yes)
    Attachment (v11-0002-Add-MODE-option-to-WAIT-FOR-LSN-command.patch) at 2025-12-30 06:19:27 from Xuneng Zhou <xunengzhou at gmail.com> (Patch: Yes)
    Attachment (v10-0004-Use-WAIT-FOR-LSN-in-PostgreSQL-Test-Cluster-wait.patch) at 2025-12-30 02:42:09 from Xuneng Zhou <xunengzhou at gmail.com> (Patch: Yes)
    Attachment (v9-0001-Extend-xlogwait-infrastructure-with-write-and-flu.patch) at 2025-12-30 02:12:28 from Xuneng Zhou <xunengzhou at gmail.com> (Patch: Yes)
    Attachment (v8-0001-Extend-xlogwait-infrastructure-with-write-and-flu.patch) at 2025-12-26 16:15:05 from Xuneng Zhou <xunengzhou at gmail.com> (Patch: Yes)
    Attachment (synchronous_commit.png) at 2025-12-22 07:56:59 from Xuneng Zhou <xunengzhou at gmail.com> (Patch: No)
    Attachment (v7-0001-Extend-xlogwait-infrastructure-with-write-and-flu.patch) at 2025-12-19 02:49:46 from Xuneng Zhou <xunengzhou at gmail.com> (Patch: Yes)
    Attachment (v6-0001-Extend-xlogwait-infrastructure-with-write-and-flu.patch) at 2025-12-16 04:46:27 from Xuneng Zhou <xunengzhou at gmail.com> (Patch: Yes)
    Attachment (v5-0003-Add-tab-completion-for-WAIT-FOR-LSN-MODE-paramete.patch) at 2025-12-16 03:28:51 from Xuneng Zhou <xunengzhou at gmail.com> (Patch: Yes)
    Attachment (v4-0004-Use-WAIT-FOR-LSN-in.patch) at 2025-12-02 10:10:02 from Xuneng Zhou <xunengzhou at gmail.com> (Patch: Yes)
    Attachment (v3-0005-Use-WAIT-FOR-LSN-in.patch) at 2025-12-02 03:08:01 from Xuneng Zhou <xunengzhou at gmail.com> (Patch: Yes)
    Attachment (v2-0005-Use-WAIT-FOR-LSN-in.patch) at 2025-12-01 04:33:27 from Xuneng Zhou <xunengzhou at gmail.com> (Patch: Yes)
    Attachment (v1-0002-Add-pg_last_wal_write_lsn-SQL-function.patch) at 2025-11-25 11:51:19 from Xuneng Zhou <xunengzhou at gmail.com> (Patch: Yes)
    Attachment (v3-0001-Optimize-shared-memory-usage-for-WaitLSNProcInfo.patch) at 2025-11-16 12:08:58 from Alexander Korotkov <aekorotkov at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Fix-incorrect-function-name-in-comments.patch) at 2025-11-14 01:49:51 from Xuneng Zhou <xunengzhou at gmail.com> (Patch: Yes)
    Attachment (v2-0001-Use-WAIT-FOR-LSN-in.patch) at 2025-11-12 07:19:53 from Xuneng Zhou <xunengzhou at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Optimize-shared-memory-usage-for-WaitLSNProcInfo.patch) at 2025-11-07 22:02:36 from Alexander Korotkov <aekorotkov at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Use-WAIT-FOR-LSN-in-PostgreSQL-Test-Cluster-wait_.patch) at 2025-11-05 09:51:18 from Alexander Korotkov <aekorotkov at gmail.com> (Patch: Yes)
    Attachment (v20-0002-Add-infrastructure-for-efficient-LSN-waiting.patch) at 2025-11-03 11:46:40 from Alexander Korotkov <aekorotkov at gmail.com> (Patch: Yes)
    Attachment (v19-0002-Add-infrastructure-for-efficient-LSN-waiting.patch) at 2025-11-03 02:20:28 from Xuneng Zhou <xunengzhou at gmail.com> (Patch: Yes)
    Attachment (v18-0001-Add-pairingheap_initialize-for-shared-memory-usa.patch) at 2025-11-02 06:24:48 from Xuneng Zhou <xunengzhou at gmail.com> (Patch: Yes)
    Attachment (v17-0001-Add-pairingheap_initialize-for-shared-memory-usa.patch) at 2025-10-23 10:46:27 from Alexander Korotkov <aekorotkov at gmail.com> (Patch: Yes)
    Attachment (v16-0001-Add-pairingheap_initialize-for-shared-memory-usag.patch) at 2025-10-16 07:11:58 from Xuneng Zhou <xunengzhou at gmail.com> (Patch: Yes)
    Attachment (v16-0001-Add-pairingheap_initialize-for-shared-memory-usag copy.patch) at 2025-10-15 12:48:29 from Xuneng Zhou <xunengzhou at gmail.com> (Patch: Yes)
    Attachment (v15-0001-Add-pairingheap_initialize-for-shared-memory-usag copy.patch) at 2025-10-15 08:40:03 from Xuneng Zhou <xunengzhou at gmail.com> (Patch: Yes)
    Attachment (v14-0003-Implement-WAIT-FOR-command.patch) at 2025-10-15 00:23:09 from Xuneng Zhou <xunengzhou at gmail.com> (Patch: Yes)
    Attachment (v13-0003-Implement-WAIT-FOR-command.patch) at 2025-10-14 13:03:30 from Xuneng Zhou <xunengzhou at gmail.com> (Patch: Yes)
    Attachment (v12-0001-Implement-WAIT-FOR-command.patch) at 2025-10-04 01:35:32 from Xuneng Zhou <xunengzhou at gmail.com> (Patch: Yes)
    Attachment (v11-0001-Implement-WAIT-FOR-command.patch) at 2025-09-28 09:02:43 from Xuneng Zhou <xunengzhou at gmail.com> (Patch: Yes)
    Attachment (v10-0001-Implement-WAIT-FOR-command.patch) at 2025-09-15 18:59:42 from Alexander Korotkov <aekorotkov at gmail.com> (Patch: Yes)
    Attachment (v9-0001-Implement-WAIT-FOR-command.patch) at 2025-09-13 19:31:32 from Alexander Korotkov <aekorotkov at gmail.com> (Patch: Yes)
    Attachment (v8-0001-Implement-WAIT-FOR-command.patch) at 2025-08-27 15:54:25 from Xuneng Zhou <xunengzhou at gmail.com> (Patch: Yes)
    Attachment (v7-0001-Implement-WAIT-FOR-command.patch) at 2025-08-05 13:47:07 from Álvaro Herrera <alvherre at kurilemu.de> (Patch: Yes)
    Attachment (v6-0001-Implement-WAIT-FOR-command.patch) at 2025-04-29 11:27:25 from Alexander Korotkov <aekorotkov at gmail.com> (Patch: Yes)
    Attachment (v6-0001-Implement-WAIT-FOR-command.patch) at 2025-03-12 14:44:28 from Yura Sokolov <y.sokolov at postgrespro.ru> (Patch: Yes)
    Attachment (v5-0001-Implement-WAIT-FOR-command.patch) at 2025-03-10 11:30:31 from Alexander Korotkov <aekorotkov at gmail.com> (Patch: Yes)
    Attachment (v4-0001-Implement-WAIT-FOR-command.patch) at 2025-02-28 13:55:21 from Yura Sokolov <y.sokolov at postgrespro.ru> (Patch: Yes)
    Attachment (v3-0001-Implement-WAIT-FOR-command.patch) at 2025-02-28 13:03:33 from Yura Sokolov <y.sokolov at postgrespro.ru> (Patch: Yes)
    Attachment (v2-0001-Implement-WAIT-FOR-command.patch) at 2025-02-16 21:27:43 from Alexander Korotkov <aekorotkov at gmail.com> (Patch: Yes)
    Attachment (v2-0001-Implement-WAIT-FOR-command.patch) at 2025-02-06 07:42:12 from Andrei Lepikhov <lepihov at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Implement-WAIT-FOR-command.patch) at 2024-11-27 04:08:51 from Alexander Korotkov <aekorotkov at gmail.com> (Patch: Yes)
History
When Who What
2025-11-15 23:31:56 Alexander Korotkov (smagen) Closed in commitfest PG19-3 with status: Committed
2025-11-15 23:31:56 Alexander Korotkov (smagen) Changed committer to smagen
2025-11-15 23:27:23 CFbot Patch needs rebase
2025-10-18 07:53:38 Xuneng Zhou (dylanzhou) Changed authors to Alexander Korotkov (smagen), Xuneng Zhou (egoa)
2025-10-16 07:37:29 CFbot Patch does not need rebase anymore
2025-10-15 09:43:22 CFbot Patch needs rebase
2025-10-15 00:47:29 CFbot Patch does not need rebase anymore
2025-10-14 13:33:20 CFbot Patch needs rebase
2025-10-13 14:00:09 Xuneng Zhou (dylanzhou) Moved from CF PG19-2 to CF PG19-3
2025-08-06 10:56:28 CFbot Patch does not need rebase anymore
2025-08-05 12:53:40 Álvaro Herrera (alvherre) Moved from CF 2025-03 to CF PG19-2
2025-08-05 12:53:36 Álvaro Herrera (alvherre) New status: Needs review
2025-03-26 09:40:13 vigneshwaran C (vignesh.postgres) New status: Waiting on Author
2025-03-19 17:52:32 CFbot Patch needs rebase
2025-03-13 11:18:19 Alexander Korotkov (smagen) Changed name to Waiting for LSN replay with WAIT FOR command
2025-02-28 13:31:41 CFbot Patch does not need rebase anymore
2025-02-21 02:39:31 CFbot Patch needs rebase
2025-02-06 08:34:53 Yura Sokolov (funny_falcon) Added funny_falcon as reviewer
2025-02-06 07:40:54 Andrei Lepikhov (lepikhov) Changed authors to Alexander Korotkov (smagen)
2025-02-06 07:40:34 Andrei Lepikhov (lepikhov) Attached mail thread CAPpHfdsjtZLVzxjGT8rJHCYbM0D5dwkO+BBjcirozJ6nYbOW8Q@mail.gmail.com
2025-02-06 07:40:33 Andrei Lepikhov (lepikhov) Created patch record
Edit