Change last_inactive_time to inactive_since in pg_replication_slots.
Amit Kapila <akapila@postgresql.org>
Change last_inactive_time to inactive_since in pg_replication_slots. Commit a11f330b55 added last_inactive_time to show the last time the slot was inactive. But, it tells the last time that a currently-inactive slot previously *WAS* active. This could be unclear, so we changed the name to inactive_since. Reported-by: Robert Haas Author: Bharath Rupireddy Reviewed-by: Bertrand Drouvot, Shveta Malik, Amit Kapila Discussion: https://postgr.es/m/CA+Tgmob_Ta-t2ty8QrKHBGnNLrf4ZYcwhGHGFsuUoFrAEDw4sA@mail.gmail.com Discussion: https://postgr.es/m/CALj2ACUXS0SfbHzsX8bqo+7CZhocsV52Kiu7OWGb5HVPAmJqnA@mail.gmail.com
Files
| Path | Change | +/− |
|---|---|---|
| doc/src/sgml/system-views.sgml | modified | +2 −2 |
| src/backend/catalog/system_views.sql | modified | +1 −1 |
| src/backend/replication/slot.c | modified | +10 −7 |
| src/backend/replication/slotfuncs.c | modified | +2 −2 |
| src/include/catalog/catversion.h | modified | +1 −1 |
| src/include/catalog/pg_proc.dat | modified | +1 −1 |
| src/include/replication/slot.h | modified | +2 −2 |
| src/test/recovery/t/019_replslot_limit.pl | modified | +31 −31 |
| src/test/regress/expected/rules.out | modified | +2 −2 |
Documentation touched
Discussion
- pgsql: Track last_inactive_time in pg_replication_slots. 33 messages · 2024-03-25 → 2024-03-27
- Introduce XID age and inactive timeout based replication slot invalidation 414 messages · 2024-01-11 → 2025-02-20