Re: Add pg_stat_autovacuum_priority

Sami Imseih <samimseih@gmail.com>

From: Sami Imseih <samimseih@gmail.com>

To: Nathan Bossart <nathandbossart@gmail.com>

Cc: Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>, Robert Treat <rob@xzilla.net>, satyanarlapuram@gmail.com, pgsql-hackers <pgsql-hackers@postgresql.org>

Date: 2026-04-01T18:45:59Z

Lists: pgsql-hackers

Attachments

v6-0003-Refactor-autovacuum-score-computation-into-comput.patch (application/octet-stream) patch v6-0003
v6-0002-Add-elevel-parameter-to-relation_needs_vacanalyze.patch (application/octet-stream) patch v6-0002
v6-0004-Add-pg_stat_autovacuum_priority-view.patch (application/octet-stream) patch v6-0004
v6-0001-Always-compute-autovacuum-priority-scores.patch (application/octet-stream) patch v6-0001

v6 attached addresses a silly bug with v5-0001 that Nathan pointed out
offline. v5 was not computing the scores for vacuum,vacuum insert
and analyze thresholds for the !wraparound case.

--
Sami

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

Fix double-free in pg_stat_autovacuum_scores.
- 71ff232a5bc4 19 (unreleased) landed
Add LOG_NEVER error level code.
- 60165db6e1f2 19 (unreleased) landed
Add pg_stat_autovacuum_scores system view.
- 87f61f0c8280 19 (unreleased) landed
Remove recheck_relation_needs_vacanalyze().
- 775fe51daaef 19 (unreleased) landed
Add elevel parameter to relation_needs_vacanalyze().
- 01876ace1369 19 (unreleased) landed
Teach relation_needs_vacanalyze() to always compute scores.
- 53b8ca6881a1 19 (unreleased) landed
Refactor relation_needs_vacanalyze().
- 8261ee24fe33 19 (unreleased) landed
Add rudimentary table prioritization to autovacuum.
- d7965d65fc5b 19 (unreleased) cited
Fix per-relation memory leakage in autovacuum.
- 02502c1bca54 18.0 cited
Fix recently-understood problems with handling of XID freezing, particularly
- 48188e1621bb 8.2.0 cited