Learn about how data is stored in Postgres, how vacuuming works, and how to optimize vacuuming to minimize bloat.

6m read timeFrom supabase.com
Post cover image
Table of contents
How data of Postgres tables stored #How does the vacuum work? #Cleaning relation files #Table bloating and autovaccuum #Autovacuum hasn’t started for a table #Autovacuum started but couldn’t succeed #Other vacuum optimizations #Conclusion #

Sort: