autovacuum

Nik and Michael discuss autovacuum, including what it does, and the basics of why and how to tune it.

Here are some links to things they mentioned:
• autovacuum postgresql.org/docs/current/routine-vacuuming.…
• autovacuum configuration parameters postgresql.org/docs/current/runtime-config-vac…
• What’s Missing in Postgres? (our episode with Bruce Momjian) postgres.fm/episodes/what-s-missing-in-postgres
• pg_squeeze (our episode with Antonín Houska) postgres.fm/episodes/pg_squeeze
• My queries to monitor autovacuum (post by Laurenz Albe) cybertec-postgresql.com/en/monitor-autovacuum-…
• Autovacuum Tuning Basics (post by Tomas Vondra, originally for 2nd Quadrant blog) enterprisedb.com/blog/autovacuum-tuning-basics
• Zero autovacuum_vacuum_cost_delay, Write Storms, and You (post by Jeremy Schneider) ardentperf.com/2026/04/12/zero-autovacuum_cost…
• Our episode on long-running transactions / xmin horizon postgres.fm/episodes/long-running-transactions

~~~
What did you like or not like? What should we discuss next time? Let us know via a YouTube comment, on social media, (postgres.fm/people) or by commenting on our Google doc (docs.google.com/document/d/1PNGSn_d0A7gTR4C0p6…)!

~~~
Postgres FM is produced by:
• Michael Christofides, founder of pgMustard (pgmustard.com)
• Nikolay Samokhvalov, founder of Postgres.ai (postgres.ai)

With credit to:
• Jessie Draws for the elephant artwork