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

Title

Topic

Performance

Created

2022-08-06 18:26:34

Last modified

2022-08-31 18:50:46 (2 years, 2 months ago)

Latest email

2022-08-31 18:38:54 (2 years, 2 months ago)

Status

2022-09: Committed

Target version

Authors

Peter Geoghegan (pgeoghegan)

Reviewers

Nathan Bossart (bossartn)Become reviewer

Committer

Peter Geoghegan (pgeoghegan)

Links

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