Re: Add pg_stat_autovacuum_priority

Alexander Lakhin <exclusion@gmail.com>

From: Alexander Lakhin <exclusion@gmail.com>

To: Nathan Bossart <nathandbossart@gmail.com>, Sami Imseih <samimseih@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-08T17:00:00Z

Lists: pgsql-hackers

Hello Nathan,

07.04.2026 00:58, Nathan Bossart wrote:
> Committed after some more editorialization.

Please look at a new anomaly, I and SQLsmith have discovered:
SELECT (SELECT score FROM pg_stat_get_autovacuum_scores() LIMIT 1),
     (SELECT score FROM pg_stat_get_autovacuum_scores() LIMIT 1);
ERROR:  detected double pfree in PgStat Snapshot 0x5f6fa4d95d50

Best regards,
Alexander

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