Improve pg_sync_replication_slots() to wait for primary to advance in more cases

Edit
ID 6452
Title Improve pg_sync_replication_slots() to wait for primary to advance in more cases
CI (CFBot) Summary
Stats (from CFBot) Patch version: v2, Patch count: 2, First patch: +64−42, All patches: +136−42
Tags Logical Replication
Created 2026-02-03 09:02:21
Last modified 2026-02-03 09:02:50 (2 hours ago)
Latest email 2026-02-02 09:10:25 (yesterday)
Status
PG19-Final (2026-03-01 – 2026-03-31): Needs review
Target version
Authors Zhijie Hou (houzj)
Reviewers Become reviewer
Committer
Links
Emails
Improve pg_sync_replication_slots() to wait for primary to advance
First at 2025-06-24 10:40:58 by Ajin Cherian <itsajin at gmail.com>
Latest at 2026-02-02 09:10:25 by shveta malik <shveta.malik at gmail.com>
Latest attachment (v26-0001-Improve-initial-slot-synchronization-in-pg_sync_.patch) at 2025-11-28 04:46:18 from Ajin Cherian <itsajin at gmail.com>
    Attachment (v26-0001-Improve-initial-slot-synchronization-in-pg_sync_.patch) at 2025-11-28 04:46:18 from Ajin Cherian <itsajin at gmail.com> (Patch: Yes)
    Attachment (v25-0001-Improve-initial-slot-synchronization-in-pg_sync_.patch) at 2025-11-24 06:42:28 from Ajin Cherian <itsajin at gmail.com> (Patch: Yes)
    Attachment (v24-0001-Improve-initial-slot-synchronization-in-pg_sync_.patch) at 2025-11-21 03:44:25 from Ajin Cherian <itsajin at gmail.com> (Patch: Yes)
    Attachment (v23-0001-Improve-initial-slot-synchronization-in-pg_sync_.patch) at 2025-11-12 08:24:18 from Ajin Cherian <itsajin at gmail.com> (Patch: Yes)
    Attachment (v22-0001-Improve-initial-slot-synchronization-in-pg_sync_.patch) at 2025-11-06 07:53:02 from Ajin Cherian <itsajin at gmail.com> (Patch: Yes)
    Attachment (v21-0001-Improve-initial-slot-synchronization-in-pg_sync_.patch) at 2025-11-03 10:33:03 from Ajin Cherian <itsajin at gmail.com> (Patch: Yes)
    Attachment (v20-0001-Improve-initial-slot-synchronization-in-pg_sync_.patch) at 2025-10-30 10:18:31 from Ajin Cherian <itsajin at gmail.com> (Patch: Yes)
    Attachment (v19-0001-Improve-initial-slot-synchronization-in-pg_sync_.patch) at 2025-10-27 07:47:28 from Ajin Cherian <itsajin at gmail.com> (Patch: Yes)
    Attachment (v18-0001-Improve-initial-slot-synchronization-in-pg_sync_.patch) at 2025-10-22 04:55:17 from Ajin Cherian <itsajin at gmail.com> (Patch: Yes)
    Attachment (v17-0001-Improve-initial-slot-synchronization-in-pg_sync_.patch) at 2025-10-15 04:26:55 from Ajin Cherian <itsajin at gmail.com> (Patch: Yes)
    Attachment (v16-0001-Improve-initial-slot-synchronization-in-pg_sync_.patch) at 2025-10-13 07:57:36 from Ajin Cherian <itsajin at gmail.com> (Patch: Yes)
    Attachment (0001-Doc-update.patch.txt) at 2025-10-06 06:12:46 from shveta malik <shveta.malik at gmail.com> (Patch: Yes)
    Attachment (v15-0001-Improve-initial-slot-synchronization-in-pg_sync_.patch) at 2025-10-06 04:52:09 from shveta malik <shveta.malik at gmail.com> (Patch: Yes)
    Attachment (v15-0001-Improve-initial-slot-synchronization-in-pg_sync_.patch) at 2025-10-02 11:23:34 from Ajin Cherian <itsajin at gmail.com> (Patch: Yes)
    Attachment (v14-0001-Improve-initial-slot-synchronization-in-pg_sync_.patch) at 2025-09-24 12:05:10 from Ajin Cherian <itsajin at gmail.com> (Patch: Yes)
    Attachment (0001-comments-changes.patch.txt) at 2025-09-23 04:59:18 from shveta malik <shveta.malik at gmail.com> (Patch: Yes)
    Attachment (v13-0001-Improve-initial-slot-synchronization-in-pg_sync_.patch) at 2025-09-22 10:51:14 from Ajin Cherian <itsajin at gmail.com> (Patch: Yes)
    Attachment (v12-0001-Improve-initial-slot-synchronization-in-pg_sync_.patch) at 2025-09-15 12:47:43 from Ajin Cherian <itsajin at gmail.com> (Patch: Yes)
    Attachment (v11-0001-Improve-initial-slot-synchronization-in-pg_sync_.patch) at 2025-09-09 12:06:47 from Ajin Cherian <itsajin at gmail.com> (Patch: Yes)
    Attachment (v10-0001-Improve-initial-slot-synchronization-in-pg_sync_.patch) at 2025-09-03 09:49:39 from Ajin Cherian <itsajin at gmail.com> (Patch: Yes)
    Attachment (v10-0001-Improve-initial-slot-synchronization-in-pg_sync_.patch) at 2025-09-03 06:28:02 from Ajin Cherian <itsajin at gmail.com> (Patch: Yes)
    Attachment (v9-0001-Improve-initial-slot-synchronization-in-pg_sync_r.patch) at 2025-08-26 04:28:30 from Ajin Cherian <itsajin at gmail.com> (Patch: Yes)
    Attachment (v8-0001-Improve-initial-slot-synchronization-in-pg_sync_r.patch) at 2025-08-20 05:22:58 from Ajin Cherian <itsajin at gmail.com> (Patch: Yes)
    Attachment (v7-0001-Improve-initial-slot-synchronization-in-pg_sync_r.patch) at 2025-08-19 05:24:57 from Ajin Cherian <itsajin at gmail.com> (Patch: Yes)
    Attachment (v6-0001-Improve-initial-slot-synchronization-in-pg_sync_r.patch) at 2025-08-14 01:58:26 from Ajin Cherian <itsajin at gmail.com> (Patch: Yes)
    Attachment (v5-0001-Improve-initial-slot-synchronization-in-pg_sync_r.patch) at 2025-08-11 08:05:43 from Ajin Cherian <itsajin at gmail.com> (Patch: Yes)
    Attachment (v4-0001-Improve-initial-slot-synchronization-in-pg_sync_r.patch) at 2025-08-06 02:03:28 from Ajin Cherian <itsajin at gmail.com> (Patch: Yes)
    Attachment (v3-0001-Improve-initial-slot-synchronization-in-pg_sync_r.patch) at 2025-07-31 09:40:57 from Ajin Cherian <itsajin at gmail.com> (Patch: Yes)
    Attachment (v2-0001-Improve-initial-slot-synchronization-in-pg_sync_r.patch) at 2025-07-16 10:16:51 from Ajin Cherian <itsajin at gmail.com> (Patch: Yes)
    Attachment (v2-0001-Improve-initial-slot-synchronization-in-pg_sync_r.patch) at 2025-07-16 09:30:17 from Ajin Cherian <itsajin at gmail.com> (Patch: Yes)
    Attachment (0001-Improve-initial-slot-synchronization-in-pg_sync_repl.patch) at 2025-06-24 10:48:18 from Ajin Cherian <itsajin at gmail.com> (Patch: Yes)
    Attachment (0001-Fix-stale-snapshot-issue.patch) at 2025-06-24 10:40:58 from Ajin Cherian <itsajin at gmail.com> (Patch: Yes)
History
When Who What
2026-02-03 09:02:49 Zhijie Hou (houzj) Changed name to Improve pg_sync_replication_slots() to wait for primary to advance in more cases
2026-02-03 09:02:22 Zhijie Hou (houzj) Attached mail thread CAFPTHDZAA+gWDntpa5ucqKKba41=tXmoXqN3q4rpjO9cdxgQrw@mail.gmail.com
2026-02-03 09:02:21 Zhijie Hou (houzj) Created patch record
Edit