Shaun Thomas: Looking Forward to Postgres 19: Autovacuum Tweaks

The autovacuum process has been dutifully tending Postgres tables since version 8.1 , and almost every release since has acquired some new refinement: smarter thresholds, insert-aware triggering, resource cost limits, and so on. It's the reliable maintenance workhorse that heroically forestalls transaction ID wraparound and keeps statistics fresh. So how did the devs improve it this time around?For most of its life, an autovacuum worker built its list of tables needing attention and then worked through them in roughly the order they appear in the catalog. Very egalitarian. But a table one tran