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 (1 year, 7 months ago)

Latest email

2022-08-31 18:38:54 (1 year, 7 months ago)

Status

2022-09: Committed

Target version

Authors

Peter Geoghegan (pgeoghegan)

Reviewers

Nathan Bossart (bossartn)Become reviewer

Committer

Peter Geoghegan (pgeoghegan)

Links

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