fix autovacuum scoring corner case

Edit
ID 7235
Title fix autovacuum scoring corner case
CI (CFBot) Summary
Stats (from CFBot) Patch version: v1, Patch count: 1, First patch: +8−2, All patches: +8−2
Tags Bugfix
Created 2026-08-31 15:23:52
Last modified 2026-08-31 15:23:56 (yesterday)
Latest email 2026-09-01 05:18:42 (12 hours ago)
Status
PG20-2 (2026-09-01 – 2026-09-30): Ready for Committer
Target version stable
Authors Nathan Bossart (bossartn)
Reviewers Become reviewer
Committer Nathan Bossart (bossartn)
Links
Emails
another autovacuum scheduling thread
First at 2025-10-08 15:18:17 by Nathan Bossart <nathandbossart at gmail.com>
Latest at 2026-09-01 05:18:42 by "Greg Burd" <greg at burd.me>
Latest attachment (v1-0001-Fix-backwards-scaling-of-autovacuum-freeze-scores.patch) at 2026-08-31 15:23:26 from Nathan Bossart <nathandbossart at gmail.com>
    Attachment (v1-0001-Fix-backwards-scaling-of-autovacuum-freeze-scores.patch) at 2026-08-31 15:23:26 from Nathan Bossart <nathandbossart at gmail.com> (Patch: No)
    Attachment (v17-0001-Add-rudimentary-table-prioritization-to-autovacu.patch) at 2026-03-26 16:49:56 from Nathan Bossart <nathandbossart at gmail.com> (Patch: No)
    Attachment (v16-0001-Add-rudimentary-table-prioritization-to-autovacu.patch) at 2026-03-25 22:10:43 from Nathan Bossart <nathandbossart at gmail.com> (Patch: No)
    Attachment (v15-0001-autovacuum-scheduling-improvements.patch) at 2026-03-24 17:15:14 from Nathan Bossart <nathandbossart at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Add-pg_stat_autovacuum_priority-view.patch) at 2026-03-23 19:01:22 from Sami Imseih <samimseih at gmail.com> (Patch: Yes)
    Attachment (v14-0001-autovacuum-scheduling-improvements.patch) at 2026-03-20 20:31:30 from Nathan Bossart <nathandbossart at gmail.com> (Patch: Yes)
    Attachment (v13-0001-autovacuum-scheduling-improvements.patch) at 2026-03-19 15:49:33 from Nathan Bossart <nathandbossart at gmail.com> (Patch: Yes)
    Attachment (autovacuum_simulation_v3.py) at 2026-03-19 13:49:34 from "Greg Burd" <greg at burd.me> (Patch: No)
    Attachment (v20260318-0001-autovacuum-scheduling-improvements.patch) at 2026-03-19 09:55:49 from "Greg Burd" <greg at burd.me> (Patch: Yes)
    Attachment (v12-0001-autovacuum-scheduling-improvements.patch) at 2026-03-18 16:09:31 from Nathan Bossart <nathandbossart at gmail.com> (Patch: Yes)
    Attachment (v11-0001-autovacuum-scheduling-improvements.patch) at 2026-03-11 15:53:23 from Nathan Bossart <nathandbossart at gmail.com> (Patch: Yes)
    Attachment (v1-0001-autovacuum-scheduling-improvements-docs.patch) at 2026-03-11 00:11:27 from Sami Imseih <samimseih at gmail.com> (Patch: Yes)
    Attachment (v10-0001-autovacuum-scheduling-improvements.patch) at 2026-03-10 16:19:20 from Nathan Bossart <nathandbossart at gmail.com> (Patch: Yes)
    Attachment (v9-0001-autovacuum-scheduling-improvements.patch) at 2026-03-10 15:06:44 from Nathan Bossart <nathandbossart at gmail.com> (Patch: Yes)
    Attachment (v8-0001-autovacuum-scheduling-improvements.patch) at 2025-11-11 16:36:32 from Nathan Bossart <nathandbossart at gmail.com> (Patch: Yes)
    Attachment (0001-autovacuum-score-logging-and-sort-enable-disable.txt) at 2025-11-06 22:21:40 from Sami Imseih <samimseih at gmail.com> (Patch: Yes)
    Attachment (batch.sh) at 2025-10-31 00:38:15 from Sami Imseih <samimseih at gmail.com> (Patch: No)
    Attachment (v7-0001-autovacuum-scheduling-improvements.patch) at 2025-10-29 15:51:18 from Nathan Bossart <nathandbossart at gmail.com> (Patch: Yes)
    Attachment (v6-0001-autovacuum-scheduling-improvements.patch) at 2025-10-28 21:03:23 from Nathan Bossart <nathandbossart at gmail.com> (Patch: Yes)
    Attachment (v5-0001-autovacuum-scheduling-improvements.patch) at 2025-10-27 16:06:26 from Nathan Bossart <nathandbossart at gmail.com> (Patch: Yes)
    Attachment (v4-0001-autovacuum-scheduling-improvements.patch) at 2025-10-24 15:08:42 from Nathan Bossart <nathandbossart at gmail.com> (Patch: Yes)
    Attachment (v3-0001-autovacuum-scheduling-improvements.patch) at 2025-10-21 14:38:41 from Nathan Bossart <nathandbossart at gmail.com> (Patch: Yes)
    Attachment (v2-0001-autovacuum-scheduling-improvements.patch) at 2025-10-10 17:31:13 from Nathan Bossart <nathandbossart at gmail.com> (Patch: Yes)
    Attachment (v1-0001-autovacuum-order-tables-by-m-xid-age.patch) at 2025-10-08 15:18:17 from Nathan Bossart <nathandbossart at gmail.com> (Patch: Yes)
History
When Who What
2026-08-31 15:23:56 Nathan Bossart (bossartn) New status: Ready for Committer
2026-08-31 15:23:54 Nathan Bossart (bossartn) Added bossartn as committer
2026-08-31 15:23:52 Nathan Bossart (bossartn) Attached mail thread aOaAuXREwnPZVISO@nathan
2026-08-31 15:23:52 Nathan Bossart (bossartn) Created patch record
Edit