Introduce XID age and inactive timeout based replication slot invalidation

Edit
ID 4770
Title Introduce XID age and inactive timeout based replication slot invalidation
Topic Replication & Recovery
Created 2024-01-11 05:20:46
Last modified 2024-12-03 07:22:31 (2 weeks, 4 days ago)
Latest email 2024-12-20 09:42:06 (1 day, 8 hours ago)
Status
2025-01: Needs review
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)Become reviewer
Committer
Links CFbot results (CirrusCI) CFbot GitHub
Checkout latest CFbot patchset Go to your local checkout of the PostgreSQL repository and run:
git remote add commitfest https://github.com/postgresql-cfbot/postgresql.git
git fetch commitfest cf/4770
git checkout commitfest/cf/4770
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 2024-12-20 09:42:06 by Amit Kapila <amit.kapila16 at gmail.com>
Latest 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>
    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
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