VACUUM and autovacuum: why PostgreSQL needs someone to clean up
A 200 GB PostgreSQL database with tables bloated to three times their actual size. Autovacuum was enabled but poorly configured. How to diagnose bloat, read pg_stat_user_tables, and tune without disabling anything.
·6 mins