Re: Add pg_stat_autovacuum_priority

Sami Imseih <samimseih@gmail.com>

From: Sami Imseih <samimseih@gmail.com>

To: Robert Treat <rob@xzilla.net>

Cc: Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>, satyanarlapuram@gmail.com, pgsql-hackers <pgsql-hackers@postgresql.org>

Date: 2026-03-30T18:16:07Z

Lists: pgsql-hackers

Attachments

v3-0002-Refactor-autovacuum-score-computation-into-comput.patch (application/octet-stream) patch v3-0002
v3-0001-Add-force_scores-option-to-relation_needs_vacanal.patch (application/octet-stream) patch v3-0001
v3-0003-Add-pg_stat_autovacuum_priority-view.patch (application/octet-stream) patch v3-0003

> I think we are also in agreement here, although based on my
> experience, filtering out things like system and toast tables will be
> common, but I don't see that changing what you said above.  On a
> similar note, +1 to your changes in v2.

Thanks!

v3 now includes the refactoring [1] suggestion brought up by Alvarro


[1] [https://www.postgresql.org/message-id/202603301508.up22nvhgnnoj%40alvherre.pgsql]

--
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