Bugfixes for WAIT FOR LSN

Edit
ID 6662
Title Bugfixes for WAIT FOR LSN
CI (CFBot) Summary
Stats (from CFBot) Patch version: v3, Patch count: 5, First patch: +10−2, All patches: +233−52
Tags Bugfix
Created 2026-04-09 15:23:44
Last modified 2026-04-09 15:23:45 (2 hours ago)
Latest email 2026-04-09 16:18:14 (1 hour ago)
Status
PG20-Drafts (2026-03-01 – 2027-02-28): Needs review
Target version 19
Authors Xuneng Zhou (egoa)
Reviewers Become reviewer
Committer
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-04-09 16:18:14 by Andres Freund <andres at anarazel.de>
Latest 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>
    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-04-09 15:23:45 Alexander Korotkov (smagen) Attached mail thread CAPpHfdsjtZLVzxjGT8rJHCYbM0D5dwkO+BBjcirozJ6nYbOW8Q@mail.gmail.com
2026-04-09 15:23:45 Alexander Korotkov (smagen) Created patch record
Edit