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-10-05 07:20:36 (1 month, 2 weeks ago)
Latest email 2024-11-21 12:05:01 (3 hours, 40 minutes ago)
Status
2024-11: Needs review
2024-09: Moved to next CF
2024-07: Moved to next CF
2024-03: Moved to next CF
Target version
Authors Bharath Rupireddy (bharathrupireddy)
Reviewers Nathan Bossart (bossartn)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-11-21 12:05:01 by Nisha Moond <nisha.moond412 at gmail.com>
Latest 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>
    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-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