Add MODE parameter to WAIT FOR LSN command

Log in to edit
ID 6265
Title Add MODE parameter to WAIT FOR LSN command
CI (CFBot) Summary
Stats (from CFBot) Patch version: v1, Patch count: 2, First patch: +16−1, All patches: +58−12
Tags
Created 2025-11-30 08:35:01
Last modified 2026-01-08 00:59:11 (10 months ago)
Latest email 2026-09-13 09:57:18 (2 months ago)
Status
PG19-4 (2026-01-01 – 2026-01-31): Committed
Target version 19
Authors Xuneng Zhou (dylanzhou)
Reviewers Log in to 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
2026-01-08 00:59:11 Xuneng Zhou (dylanzhou) Closed in commitfest PG19-4 with status: Committed
2026-01-08 00:59:11 Xuneng Zhou (dylanzhou) Changed committer to smagen
2025-11-30 08:35:01 Xuneng Zhou (dylanzhou) Attached mail thread CAPpHfdsjtZLVzxjGT8rJHCYbM0D5dwkO+BBjcirozJ6nYbOW8Q@mail.gmail.com
2025-11-30 08:35:01 Xuneng Zhou (dylanzhou) Created patch record
Log in to edit