Avoid repetitive vac_update_datfrozenxid() during vacuumdb

Title

Topic

Performance

Created

2022-12-28 20:16:28

Last modified

2023-01-06 19:17:51 (1 year, 8 months ago)

Latest email

2023-01-06 17:53:07 (1 year, 8 months ago)

Status

2023-01: Committed

Target version

Authors

Tom Lane (tgl)

Reviewers

Nathan Bossart (bossartn)Become reviewer

Committer

Tom Lane (tgl)

Links

Emails

BUG #17717: Regression in vacuumdb (15 is slower than 10/11 and possible memory issue): First at 2022-12-13 10:57:39 by PG Bug reporting form <noreply at postgresql.org>
Latest at 2023-01-06 17:53:07 by Tom Lane <tgl at sss.pgh.pa.us>
Latest attachment (v1-0001-add-UPDATE_DATFROZENXID-option-to-VACUUM.patch) at 2022-12-28 21:12:53 from Nathan Bossart <nathandbossart at gmail.com>
Attachment (v1-0001-add-UPDATE_DATFROZENXID-option-to-VACUUM.patch) at 2022-12-28 21:12:53 from Nathan Bossart <nathandbossart at gmail.com> (Patch: Yes)
Attachment (allow-vacuum-to-skip-stats-update-1.patch) at 2022-12-28 20:13:23 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: Yes)

History

When	Who	What
2023-01-06 19:17:51	Tom Lane (tgl)	Closed in commitfest 2023-01 with status: Committed
2023-01-06 19:17:51	Tom Lane (tgl)	Changed committer to tgl
2022-12-30 20:03:13	Nathan Bossart (bossartn)	Added bossartn as reviewer
2022-12-28 20:16:48	Tom Lane (tgl)	Changed authors to Tom Lane (tgl)
2022-12-28 20:16:48	Tom Lane (tgl)	Changed name to Avoid repetitive vac_update_datfrozenxid() during vacuumdb
2022-12-28 20:16:29	Tom Lane (tgl)	Attached mail thread 17717-6c50eb1c7d23a886@postgresql.org
2022-12-28 20:16:28	Tom Lane (tgl)	Created patch record