Introduce XID age and inactive timeout based replication slot invalidation

Edit
Title Introduce XID age and inactive timeout based replication slot invalidation
Topic Replication & Recovery
Created 2024-01-11 05:20:46
Last modified 2024-04-09 06:34:12 (3 weeks, 1 day ago)
Latest email 2024-04-29 04:03:28 (2 days, 15 hours ago)
Status
2024-07: Needs review
2024-03: Moved to next CF
Target version
Authors Bharath Rupireddy (bharathrupireddy)
Reviewers Nathan Bossart (bossartn)Become reviewer
Committer
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 2024-04-29 04:03:28 by Amit Kapila <amit.kapila16 at gmail.com>
Latest 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>
    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-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