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! Needs rebase since 10 months.
Additional links previous successfully applied patch (outdated):
Summary
Stats (from CFBot) Unknown
Topic Replication & Recovery
Tags
Created 2024-01-11 05:20:46
Last modified 2025-02-20 03:38:41 (10 months ago)
Latest email 2025-02-20 06:11:27 (10 months ago)
Status
2025-03 (2025-03-01 – 2025-04-08): Committed
2025-01 (2025-01-01 – 2025-01-31): Moved to different CF
2024-11 (2024-11-01 – 2024-11-30): Moved to different CF
2024-09 (2024-09-01 – 2024-09-30): Moved to different CF
2024-07 (2024-07-01 – 2024-07-31): Moved to different CF
2024-03 (2024-03-01 – 2024-04-08): Moved to different 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