Introduce XID age and inactive timeout based replication slot invalidation

Edit
ID 4770
Title Introduce XID age and inactive timeout based replication slot invalidation
CI (CFBot) Needs rebase! Additional links previous successfully applied patch (outdated): Summary
Stats (from CFBot) Unknown
Topic Replication & Recovery
Created 2024-01-11 05:20:46
Last modified 2025-02-20 03:38:41 (1 day, 12 hours ago)
Latest email 2025-02-20 06:11:27 (1 day, 9 hours ago)
Status
2025-03: Committed
2025-01: Moved to next CF
2024-11: Moved to next CF
2024-09: Moved to next CF
2024-07: Moved to next CF
2024-03: Moved to next CF
Target version
Authors Bharath Rupireddy (bharathrupireddy), Nisha Moond (nishamoond)
Reviewers Nathan Bossart (bossartn), vigneshwaran C (vignesh.postgres), Peter Smith (smithpb2250), Shlok Kyal (shlokkyal)Become reviewer
Committer Amit Kapila (amitkapila)
Links
Emails
Introduce XID age and inactive timeout based replication slot invalidation
First at 2024-01-11 05:18:13 by Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com>
Latest at 2025-02-20 06:11:27 by Amit Kapila <amit.kapila16 at gmail.com>
Latest attachment (v79-0001-Introduce-inactive_timeout-based-replication-slo.patch) at 2025-02-17 06:20:41 from Nisha Moond <nisha.moond412 at gmail.com>
    Attachment (v79-0001-Introduce-inactive_timeout-based-replication-slo.patch) at 2025-02-17 06:20:41 from Nisha Moond <nisha.moond412 at gmail.com> (Patch: Yes)
    Attachment (v78_amit.1.patch.txt) at 2025-02-17 05:59:24 from Amit Kapila <amit.kapila16 at gmail.com> (Patch: Yes)
    Attachment (v78-0001-Introduce-inactive_timeout-based-replication-slo.patch) at 2025-02-14 12:00:16 from Nisha Moond <nisha.moond412 at gmail.com> (Patch: Yes)
    Attachment (v75-0001-Introduce-inactive_timeout-based-replication-slo.patch) at 2025-02-11 13:36:05 from Nisha Moond <nisha.moond412 at gmail.com> (Patch: Yes)
    Attachment (0001-fix-if-condition.patch) at 2025-02-11 06:12:31 from "Zhijie Hou (Fujitsu)" <houzj.fnst at fujitsu.com> (Patch: Yes)
    Attachment (PS_topup_for_v740001.txt) at 2025-02-11 03:19:20 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)
    Attachment (v74-0001-Introduce-inactive_timeout-based-replication-slo.patch) at 2025-02-10 13:27:25 from Nisha Moond <nisha.moond412 at gmail.com> (Patch: Yes)
    Attachment (v73-0001-Introduce-inactive_timeout-based-replication-slo.patch) at 2025-02-10 12:03:07 from Nisha Moond <nisha.moond412 at gmail.com> (Patch: Yes)
    Attachment (v210-0001-ps-tmp-topup-nisha-v720001.txt) at 2025-02-10 06:03:02 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)
    Attachment (v72-0001-Introduce-inactive_timeout-based-replication-slo.patch) at 2025-02-07 13:05:33 from Nisha Moond <nisha.moond412 at gmail.com> (Patch: Yes)
    Attachment (v71-0001-Introduce-inactive_timeout-based-replication-slo.patch) at 2025-02-06 10:38:17 from Nisha Moond <nisha.moond412 at gmail.com> (Patch: Yes)
    Attachment (v70-amit.1.patch.txt) at 2025-02-06 04:47:05 from Amit Kapila <amit.kapila16 at gmail.com> (Patch: Yes)
    Attachment (v70-0001-Introduce-inactive_timeout-based-replication-slo.patch) at 2025-02-06 02:32:29 from Nisha Moond <nisha.moond412 at gmail.com> (Patch: Yes)
    Attachment (v69-0001-Introduce-inactive_timeout-based-replication-slo.patch) at 2025-02-04 14:26:00 from Nisha Moond <nisha.moond412 at gmail.com> (Patch: Yes)
    Attachment (v68-0001-Introduce-inactive_timeout-based-replication-slo.patch) at 2025-02-04 10:27:51 from Nisha Moond <nisha.moond412 at gmail.com> (Patch: Yes)
    Attachment (v67-0001-Introduce-inactive_timeout-based-replication-slo.patch) at 2025-02-03 14:33:57 from Nisha Moond <nisha.moond412 at gmail.com> (Patch: Yes)
    Attachment (Vignesh_review_comment_fix.patch) at 2025-02-01 06:11:53 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v66-0001-Introduce-inactive_timeout-based-replication-slo.patch) at 2025-01-31 12:20:26 from Nisha Moond <nisha.moond412 at gmail.com> (Patch: Yes)
    Attachment (v65-0001-Raise-Error-for-Invalid-Slots-in-ReplicationSlot.patch) at 2025-01-31 02:13:16 from Nisha Moond <nisha.moond412 at gmail.com> (Patch: Yes)
    Attachment (v64-0001-Introduce-inactive_timeout-based-replication-slo.patch) at 2025-01-28 11:58:29 from Nisha Moond <nisha.moond412 at gmail.com> (Patch: Yes)
    Attachment (v63-0001-Enhance-replication-slot-error-handling-slot-inv.patch) at 2025-01-27 05:30:15 from Nisha Moond <nisha.moond412 at gmail.com> (Patch: Yes)
    Attachment (v62-0001-Enhance-replication-slot-error-handling-slot-inv.patch) at 2025-01-22 05:16:45 from Nisha Moond <nisha.moond412 at gmail.com> (Patch: Yes)
    Attachment (v61-0001-Enhance-replication-slot-error-handling-slot-inv.patch) at 2025-01-20 08:03:54 from Nisha Moond <nisha.moond412 at gmail.com> (Patch: Yes)
    Attachment (v60-0001-Enhance-replication-slot-error-handling-slot-inv.patch) at 2025-01-16 07:05:16 from Nisha Moond <nisha.moond412 at gmail.com> (Patch: Yes)
    Attachment (v59-0001-Enhance-replication-slot-error-handling-slot-inv.patch) at 2025-01-02 10:27:10 from Nisha Moond <nisha.moond412 at gmail.com> (Patch: Yes)
    Attachment (v58-0001-Enhance-replication-slot-error-handling-slot-inv.patch) at 2024-12-31 07:00:32 from Nisha Moond <nisha.moond412 at gmail.com> (Patch: Yes)
    Attachment (PS_diffs_v570001.txt) at 2024-12-30 01:15:19 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)
    Attachment (log_1.tgz) at 2024-12-24 12:57:15 from Michail Nikolaev <michail.nikolaev at gmail.com> (Patch: No)
    Attachment (v57-0001-Enhance-replication-slot-error-handling-slot-inv.patch) at 2024-12-24 11:36:55 from Nisha Moond <nisha.moond412 at gmail.com> (Patch: Yes)
    Attachment (v56-0001-Enhance-replication-slot-error-handling-slot-inv.patch) at 2024-12-16 10:40:28 from Nisha Moond <nisha.moond412 at gmail.com> (Patch: Yes)
    Attachment (v55-0001-Enhance-replication-slot-error-handling-slot-inv.patch) at 2024-12-13 10:58:58 from Nisha Moond <nisha.moond412 at gmail.com> (Patch: Yes)
    Attachment (v54-0001-Enhance-replication-slot-error-handling-slot-inv.patch) at 2024-12-10 11:51:09 from Nisha Moond <nisha.moond412 at gmail.com> (Patch: Yes)
    Attachment (v53-0001-Enhance-replication-slot-error-handling-slot-inv.patch) at 2024-12-04 09:30:52 from Nisha Moond <nisha.moond412 at gmail.com> (Patch: Yes)
    Attachment (v52-0001-Enhance-replication-slot-error-handling-slot-inv.patch) at 2024-11-29 12:36:02 from Nisha Moond <nisha.moond412 at gmail.com> (Patch: Yes)
    Attachment (v51-0001-Add-error-handling-while-acquiring-a-replication.patch) at 2024-11-27 10:54:49 from Nisha Moond <nisha.moond412 at gmail.com> (Patch: Yes)
    Attachment (v50-0001-Add-error-handling-while-acquiring-a-replication.patch) at 2024-11-21 12:05:01 from Nisha Moond <nisha.moond412 at gmail.com> (Patch: Yes)
    Attachment (v49-0001-Add-error-handling-while-acquiring-a-replication.patch) at 2024-11-19 07:12:55 from Nisha Moond <nisha.moond412 at gmail.com> (Patch: Yes)
    Attachment (v48-0001-Introduce-inactive_timeout-based-replication-slo.patch) at 2024-11-13 09:30:28 from Nisha Moond <nisha.moond412 at gmail.com> (Patch: Yes)
    Attachment (v47-0001-Introduce-inactive_timeout-based-replication-slo.patch) at 2024-11-07 10:03:33 from Nisha Moond <nisha.moond412 at gmail.com> (Patch: Yes)
    Attachment (PS_NITPICKS_20240917_SLOT_TIMEOUT_v46.txt) at 2024-09-17 01:27:24 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)
    Attachment (v46-0001-Introduce-inactive_timeout-based-replication-slo.patch) at 2024-09-16 10:01:11 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (PS_NITPICKS_20240910_SLOT_V450001_TESTS.txt) at 2024-09-10 01:34:24 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)
    Attachment (PS_NITPICKS_20240909_TIMEOUT_V450001.txt) at 2024-09-09 07:40:50 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)
    Attachment (v45-0001-Add-inactive_timeout-based-replication-slot-inva.patch) at 2024-09-08 11:54:47 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (PS_NITPICKS_v440001.txt) at 2024-09-02 08:06:44 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)
    Attachment (v44-0001-Add-inactive_timeout-based-replication-slot-inva.patch) at 2024-08-31 08:15:39 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (PS_NITPICKS_20240830_CODE_V430001.txt) at 2024-08-30 02:43:10 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)
    Attachment (v43-0002-Add-XID-age-based-replication-slot-invalidation.patch) at 2024-08-29 06:01:09 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (v42-0001-Add-inactive_timeout-based-replication-slot-inva.patch) at 2024-08-26 06:14:05 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (v41-0001-Add-inactive_timeout-based-replication-slot-inva.patch) at 2024-06-24 06:00:00 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (v40-0001-Add-inactive_timeout-based-replication-slot-inva.patch) at 2024-06-17 12:25:04 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (v39-0001-Add-inactive_timeout-based-replication-slot-inva.patch) at 2024-04-13 04:06:25 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (v38-0001-Add-inactive_timeout-based-replication-slot-inva.patch) at 2024-04-06 11:40:19 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (v37-0001-Add-inactive_timeout-based-replication-slot-inva.patch) at 2024-04-06 06:25:38 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (v36-0001-Add-inactive_timeout-based-replication-slot-inva.patch) at 2024-04-05 05:51:43 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (v35-0001-Allow-synced-slots-to-have-their-inactive_since.patch) at 2024-04-04 12:22:50 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (v34-0001-Allow-synced-slots-to-have-their-inactive_since.patch) at 2024-04-04 05:18:11 from Amit Kapila <amit.kapila16 at gmail.com> (Patch: Yes)
    Attachment (v33-0001-Allow-synced-slots-to-have-their-own-inactive_si.patch) at 2024-04-03 14:58:04 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (v32-0001-Allow-synced-slots-to-have-their-own-inactive_si.patch) at 2024-04-03 11:42:12 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (v31-0001-Allow-synced-slots-to-have-their-own-inactive_si.patch) at 2024-04-03 05:47:41 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (v30-0001-Maintain-inactive_since-for-synced-slots-correct.patch) at 2024-03-31 04:55:46 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (v29-0001-Maintain-inactive_since-for-synced-slots-correct.patch) at 2024-03-27 15:30:37 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (v28-0001-Maintain-inactive_since-for-synced-slots-correct.patch) at 2024-03-27 12:25:05 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (v27-0001-Maintain-inactive_since-for-synced-slots-correct.patch) at 2024-03-27 09:25:17 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (v26-0001-Maintain-inactive_since-for-synced-slots-correct.patch) at 2024-03-27 05:35:04 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (v25-0001-Maintain-inactive_since-for-synced-slots-correct.patch) at 2024-03-27 04:38:33 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (v24-0001-Use-less-confusing-name-for-slot-s-last_inactive.patch) at 2024-03-26 16:29:23 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (v1-0001-inactive_since-for-synced-slots.patch.txt) at 2024-03-26 09:47:36 from shveta malik <shveta.malik at gmail.com> (Patch: Yes)
    Attachment (v22-0001-Fix-review-comments-for-slot-s-last_inactive_tim.patch) at 2024-03-26 08:57:17 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (v21-0001-Fix-review-comments-for-slot-s-last_inactive_tim.patch) at 2024-03-26 05:37:51 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (v20-0001-Track-last_inactive_time-in-pg_replication_slots.patch) at 2024-03-25 10:01:15 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (v19-0001-Track-last_inactive_time-in-pg_replication_slots.patch) at 2024-03-25 06:55:21 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (v18_0001_diff_amit.patch.txt) at 2024-03-25 04:58:31 from Amit Kapila <amit.kapila16 at gmail.com> (Patch: Yes)
    Attachment (v18-0001-Track-last_inactive_time-in-pg_replication_slots.patch) at 2024-03-24 09:35:44 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (v17-0001-Track-last_inactive_time-in-pg_replication_slots.patch) at 2024-03-24 02:30:00 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (v16-0001-Track-last_inactive_time-in-pg_replication_slots.patch) at 2024-03-23 07:41:50 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (v15-0001-Track-last_inactive_time-in-pg_replication_slots.patch) at 2024-03-22 21:32:26 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (v14-0001-Track-invalidation_reason-in-pg_replication_slot.patch) at 2024-03-22 08:15:01 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (v14-0001-Track-invalidation_reason-in-pg_replication_slot.patch) at 2024-03-21 17:51:03 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (v13-0001-Track-invalidation_reason-in-pg_replication_slot.patch) at 2024-03-20 23:35:46 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (v12-0001-Track-invalidation_reason-in-pg_replication_slot.patch) at 2024-03-19 19:18:55 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (v11-0001-Track-invalidation_reason-in-pg_replication_slot.patch) at 2024-03-16 03:59:01 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (v10-0001-Track-invalidation_reason-in-pg_replication_slot.patch) at 2024-03-15 12:05:27 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (v9-0001-Track-invalidation_reason-in-pg_replication_slots.patch) at 2024-03-14 14:27:46 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (v8-0001-Track-invalidation_reason-in-pg_replication_slots.patch) at 2024-03-06 09:16:57 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (v7-0001-Track-invalidation_reason-in-pg_replication_slots.patch) at 2024-03-05 19:20:38 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (v6-0001-Track-invalidation_reason-in-pg_replication_slots.patch) at 2024-03-01 14:32:00 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (v5-0001-Track-invalidation_reason-in-pg_replication_slots.patch) at 2024-02-20 06:35:00 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (v4-0004-Add-inactive_timeout-based-replication-slot.patch) at 2024-02-06 18:52:07 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (v3-0004-Add-XID-based-replication-slot-invalidation.patch) at 2024-01-31 13:05:00 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (v2-0001-Track-invalidation_reason-in-pg_replication_slots.patch) at 2024-01-26 19:48:00 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Track-invalidation_reason-in-pg_replication_slots.patch) at 2024-01-11 05:18:13 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
History
When Who What
2025-02-20 03:38:41 Amit Kapila (amitkapila) Closed in commitfest 2025-03 with status: Committed
2025-02-20 03:38:41 Amit Kapila (amitkapila) Changed committer to amitkapila
2025-02-19 07:03:30 CFbot Patch needs rebase
2025-02-19 03:45:58 Shlok Kyal (shlokkyal) Added shlokkyal as reviewer
2025-02-05 01:09:23 Peter Smith (smithpb2250) Closed in commitfest 2025-01 with status: Moved to next CF
2025-02-05 01:09:12 Peter Smith (smithpb2250) Added smithpb2250 as reviewer
2024-12-12 04:13:50 vigneshwaran C (vignesh.postgres) Added vignesh.postgres as reviewer
2024-12-03 07:22:31 Nisha Moond (nishamoond) Changed authors to Bharath Rupireddy (bharathrupireddy), Nisha Moond (nishamoond)
2024-12-03 07:16:26 Hayato Kuroda (ha-kun) Closed in commitfest 2024-11 with status: Moved to next CF
2024-10-05 07:20:36 Bertrand Drouvot (bertranddrouvot.pg) Closed in commitfest 2024-09 with status: Moved to next CF
2024-08-01 04:46:59 Corey Huinker (coreyh) Closed in commitfest 2024-07 with status: Moved to next CF
2024-04-09 06:34:12 Andrey Borodin (x4m) Closed in commitfest 2024-03 with status: Moved to next CF
2024-03-01 22:11:31 Nathan Bossart (bossartn) Added bossartn as reviewer
2024-01-11 05:20:58 Bharath Rupireddy (bharathrupireddy) Changed authors to Bharath Rupireddy (bharathrupireddy)
2024-01-11 05:20:46 Bharath Rupireddy (bharathrupireddy) Attached mail thread CALj2ACW4aUe-_uFQOjdWCEN-xXoLGhmvRFnL8SNw_TZ5nJe+aw@mail.gmail.com
2024-01-11 05:20:46 Bharath Rupireddy (bharathrupireddy) Created patch record
Edit