Teach VACUUM to disregard long running transactions when determining XID cutoff for freezing

Edit
ID 3801
Title Teach VACUUM to disregard long running transactions when determining XID cutoff for freezing
Topic Performance
Created 2022-08-06 18:26:34
Last modified 2022-08-31 18:50:46 (2 years, 1 month ago)
Latest email 2022-08-31 18:38:54 (2 years, 1 month ago)
Status
2022-09: Committed
Target version
Authors Peter Geoghegan (pgeoghegan)
Reviewers Nathan Bossart (bossartn)Become reviewer
Committer Peter Geoghegan (pgeoghegan)
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/3801
git checkout commitfest/cf/3801
Emails
effective_multixact_freeze_max_age issue
First at 2022-08-02 23:12:18 by Peter Geoghegan <pg at bowt.ie>
Latest at 2022-08-31 18:38:54 by Peter Geoghegan <pg at bowt.ie>
Latest attachment (v2-0001-Derive-freeze-cutoff-from-nextXID-not-OldestXmin.patch) at 2022-08-31 00:24:17 from Peter Geoghegan <pg at bowt.ie>
    Attachment (v2-0001-Derive-freeze-cutoff-from-nextXID-not-OldestXmin.patch) at 2022-08-31 00:24:17 from Peter Geoghegan <pg at bowt.ie> (Patch: Yes)
    Attachment (v1-0001-Derive-VACUUM-s-FreezeLimit-from-next-transaction.patch) at 2022-08-02 23:12:18 from Peter Geoghegan <pg at bowt.ie> (Patch: Yes)
History
When Who What
2022-08-31 18:50:46 Peter Geoghegan (pgeoghegan) Closed in commitfest 2022-09 with status: Committed
2022-08-31 18:50:46 Peter Geoghegan (pgeoghegan) Changed committer to pgeoghegan
2022-08-28 23:20:55 Nathan Bossart (bossartn) Added bossartn as reviewer
2022-08-06 18:26:45 Peter Geoghegan (pgeoghegan) Changed authors to Peter Geoghegan (pgeoghegan)
2022-08-06 18:26:34 Peter Geoghegan (pgeoghegan) Attached mail thread CAH2-Wzn2hODG0KQNvtFsT-Ka=MrUNHRpQXZ8tRiiC-fudQ_kEw@mail.gmail.com
2022-08-06 18:26:34 Peter Geoghegan (pgeoghegan) Created patch record
Edit