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) Needs rebase! Needs rebase since 1 week. Failing since 1 week.
Additional links previous successfully applied patch (outdated):
Summary
Stats (from CFBot) Unknown
Tags Logical Replication
Created 2026-02-03 09:02:21
Last modified 2026-03-16 07:20:38 (2 days ago)
Latest email 2026-03-05 09:29:50 (1 week ago)
Status
PG19-Final (2026-03-01 – 2026-03-31): Committed
Target version
Authors Zhijie Hou (houzj)
Reviewers Become reviewer
Committer Amit Kapila (amitkapila)
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-03-05 09:29:50 by shveta malik <shveta.malik at gmail.com>
Latest attachment (v7-0002-Add-a-taptest.patch) at 2026-03-04 06:56:40 from "Zhijie Hou (Fujitsu)" <houzj.fnst at fujitsu.com>
    Attachment (v7-0002-Add-a-taptest.patch) at 2026-03-04 06:56:40 from "Zhijie Hou (Fujitsu)" <houzj.fnst at fujitsu.com> (Patch: Yes)
    Attachment (v6-0002-Add-a-taptest.patch) at 2026-02-13 02:24:50 from "Zhijie Hou (Fujitsu)" <houzj.fnst at fujitsu.com> (Patch: Yes)
    Attachment (v5-0004-Add-a-taptest.patch) at 2026-02-11 08:44:33 from "Zhijie Hou (Fujitsu)" <houzj.fnst at fujitsu.com> (Patch: Yes)
    Attachment (v4-0004-Add-a-taptest.patch) at 2026-02-10 07:55:19 from "Zhijie Hou (Fujitsu)" <houzj.fnst at fujitsu.com> (Patch: Yes)
    Attachment (v3-0004-Add-a-taptest.patch) at 2026-02-09 06:06:34 from "Zhijie Hou (Fujitsu)" <houzj.fnst at fujitsu.com> (Patch: Yes)
    Attachment (v2-0001-Improve-the-retry-logic-in-pg_sync_replication_sl.patch) at 2026-02-02 07:26:49 from "Zhijie Hou (Fujitsu)" <houzj.fnst at fujitsu.com> (Patch: Yes)
    Attachment (v1-0002-Add-a-taptest.patch) at 2026-01-30 05:48:06 from "Zhijie Hou (Fujitsu)" <houzj.fnst at fujitsu.com> (Patch: Yes)
    Attachment (v1-0001-Fix-an-intermittent-BF-failure.patch) at 2025-12-17 10:28:28 from "Zhijie Hou (Fujitsu)" <houzj.fnst at fujitsu.com> (Patch: Yes)
    Attachment (v37-0001-Improve-initial-slot-synchronization-in-pg_sync_.patch) at 2025-12-12 00:05:04 from Ajin Cherian <itsajin at gmail.com> (Patch: Yes)
    Attachment (v36_amit_1.patch.txt) at 2025-12-11 12:23:22 from Amit Kapila <amit.kapila16 at gmail.com> (Patch: Yes)
    Attachment (v36-0001-Improve-initial-slot-synchronization-in-pg_sync_.patch) at 2025-12-11 05:15:16 from Ajin Cherian <itsajin at gmail.com> (Patch: Yes)
    Attachment (v35-0001-Signal-backends-running-pg_sync_replication_slot.patch) at 2025-12-10 12:23:50 from Amit Kapila <amit.kapila16 at gmail.com> (Patch: Yes)
    Attachment (v34-0001-Signal-backends-running-pg_sync_replication_slot.patch) at 2025-12-10 05:07:34 from Ajin Cherian <itsajin at gmail.com> (Patch: Yes)
    Attachment (v32-0001-Signal-backends-running-pg_sync_replication_slot.patch) at 2025-12-10 02:23:10 from Ajin Cherian <itsajin at gmail.com> (Patch: Yes)
    Attachment (v31-0001-Signal-backends-running-pg_sync_replication_slot.patch) at 2025-12-09 10:33:59 from Ajin Cherian <itsajin at gmail.com> (Patch: Yes)
    Attachment (v30-0001-Use-SIGUSR1-to-interrupt-slot-synchronization-wo.patch) at 2025-12-04 09:01:04 from Ajin Cherian <itsajin at gmail.com> (Patch: Yes)
    Attachment (v29-0001-Use-SIGUSR1-to-interrupt-slot-synchronization-wo.patch) at 2025-12-04 05:21:39 from Ajin Cherian <itsajin at gmail.com> (Patch: Yes)
    Attachment (v28-0001-Improve-initial-slot-synchronization-in-pg_sync_.patch) at 2025-12-03 03:21:35 from Ajin Cherian <itsajin at gmail.com> (Patch: Yes)
    Attachment (v27-0001-Improve-initial-slot-synchronization-in-pg_sync_.patch) at 2025-12-02 08:27:57 from Ajin Cherian <itsajin at gmail.com> (Patch: Yes)
    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-03-16 07:20:38 Hayato Kuroda (ha-kun) Closed in commitfest PG19-Final with status: Committed
2026-03-16 07:09:32 Hayato Kuroda (ha-kun) Closed in commitfest PG19-Final with status: Committed
2026-03-10 04:30:16 Zhijie Hou (houzj) Closed in commitfest PG19-Final with status: Committed
2026-03-10 04:30:16 Zhijie Hou (houzj) Changed committer to amitkapila
2026-03-07 23:33:26 CFbot Patch needs rebase
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