fix autovacuum score when member space usage is high

Title

CI (CFBot)

Summary

Stats (from CFBot)

Patch version: v2, Patch count: 1, First patch: +12−5, All patches: +12−5

Tags

Bugfix

Created

2026-06-17 14:59:39

Last modified

2026-06-18 15:21:04 (1 month ago)

Latest email

2026-06-18 15:21:38 (1 month ago)

Status

PG20-1 (2026-07-01 – 2026-07-31): Committed

Target version

Authors

Sami Imseih (simseih)

Reviewers

Nathan Bossart (bossartn) Become reviewer

Committer

Nathan Bossart (bossartn)

Links

Emails

mxid_score can become Infinity in pg_stat_autovacuum_scores: First at 2026-06-12 18:19:31 by Masahiko Sawada <sawada.mshk at gmail.com>
Latest at 2026-06-18 15:21:38 by Nathan Bossart <nathandbossart at gmail.com>
Latest attachment (v2-0001-fix-division-by-zero-when-calculating-autovacuum-.patch) at 2026-06-17 16:18:39 from Nathan Bossart <nathandbossart at gmail.com>
Attachment (v2-0001-fix-division-by-zero-when-calculating-autovacuum-.patch) at 2026-06-17 16:18:39 from Nathan Bossart <nathandbossart at gmail.com> (Patch: Yes)
Attachment (v1-0001-Correct-the-MultiXact-autovacuum-priority-score-w.patch) at 2026-06-12 20:37:41 from Sami Imseih <samimseih at gmail.com> (Patch: Yes)

History

When	Who	What
2026-06-18 15:21:04	Nathan Bossart (bossartn)	Closed in commitfest PG20-1 with status: Committed
2026-06-17 18:34:30	Nathan Bossart (bossartn)	New status: Ready for Committer
2026-06-17 14:59:53	Nathan Bossart (bossartn)	Changed authors to Sami Imseih (simseih)
2026-06-17 14:59:44	Nathan Bossart (bossartn)	Added bossartn as committer
2026-06-17 14:59:43	Nathan Bossart (bossartn)	Added bossartn as reviewer
2026-06-17 14:59:39	Nathan Bossart (bossartn)	Attached mail thread CAD21AoC6nKeYAjTvJ9dmBea03GZK9222h_O=ONmcVuxfyO88Bg@mail.gmail.com
2026-06-17 14:59:39	Nathan Bossart (bossartn)	Created patch record