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, 10 months ago)

Latest email

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

Status

2023-01: Committed

Target version

Authors

Tom Lane (tgl)

Reviewers

Nathan Bossart (bossartn)Become reviewer

Committer

Tom Lane (tgl)

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/4087
git checkout commitfest/cf/4087

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