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-04T13:25:26Z

Lists: pgsql-hackers

Attachments

0001-sami_doc_fix.patch (application/octet-stream) patch 0001

> WDYT?

"Scores greater than or equal to <literal>1.0</literal>" in the comments
of each field are misleading. This conflates scoring with vacuum/analyze
eligibility and it's possible with a autovacuum_*_weight < 1.0 to trigger an
autovacuum/analyze.

I suggest the attached changes on top of v9.

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