Add MODE parameter to WAIT FOR LSN command

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
Topic Server Features
Tags
Created 2025-11-30 08:35:01
Last modified 2026-01-08 00:59:11 (4 days ago)
Latest email 2026-01-12 06:53:46 (27 minutes ago)
Status
PG19-4 (2026-01-01 – 2026-01-31): Committed
Target version 19
Authors Xuneng Zhou (dylanzhou)
Reviewers 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-01-12 06:53:46 by Xuneng Zhou <xunengzhou at gmail.com>
Latest 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>
    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
Edit