Postgres VACUUM Tuning: What autovacuum Gets Wrong by Default
Autovacuum's defaults were designed for small databases. A few parameters make a large difference at scale — and the documentation buries the relevant ones.
Autovacuum's defaults were designed for small databases. A few parameters make a large difference at scale — and the documentation buries the relevant ones.
Overview
This note is part of the field-notes archive generated for this site. The summary below is the published excerpt; you can expand the full write-up anytime in the CMS.
Related notes
Tags
- postgres
- database
- vacuum
- performance
- tuning
Manish Bookreader
Electronics enthusiast, Embedded Systems Expert, Linux/Networking programmer, and Software Engineer passionate about AI, electronics, books, and cooking.