From the source
Supabase published a guide on minimizing Postgres table bloat, explaining how heap storage and vacuuming work, and how to diagnose and address autovacuum failures.
The post covers tuning autovacuum parameters, using VACUUM FULL or pg_repack, and handling long-running transactions that prevent cleanup.





