Bloat

Michael is joined by Chelsea Dole, Staff Software Engineer and Tech Lead of the Data Storage Team at Brex, to discuss bloat. They cover what it is, why it's a problem, strategies for minimising it, and the options when it's really bad.
 
Here are some links to things they mentioned:

• Managing your tuple graveyard (talk by Chelsea) https://www.youtube.com/watch?v=gAgbzvGT6ck
• pgstattuple https://www.postgresql.org/docs/current/pgstattuple.html 
• pg_class https://www.postgresql.org/docs/current/catalog-pg-class.html 
• Bloat in PostgreSQL: a taxonomy (talk by Peter Geoghegan) https://youtube.com/watch?v=JDG4bMHxCH8 
• It's Not You, It's Me: Breaking Up with Massive Tables via Partitioning (talk by Chelsea) https://youtube.com/watch?v=TafwSuLNxe8 
• pg_repack https://github.com/reorg/pg_repack
• pg_squeeze https://github.com/cybertec-postgresql/pg_squeeze 
• VACUUM https://www.postgresql.org/docs/current/sql-vacuum.html
• autovacuum https://www.postgresql.org/docs/current/runtime-config-autovacuum.html 
• CLUSTER https://www.postgresql.org/docs/current/sql-cluster.html 
• HOT updates https://www.postgresql.org/docs/current/storage-hot.html 
• Our episode on BUFFERS https://postgres.fm/episodes/buffers-by-default 
• Our episode on TOAST https://postgres.fm/episodes/toast 
• Our episode on index maintenance https://postgres.fm/episodes/index-maintenance 
• Chelsea's website: https://chelseadole.com/

~~~

What did you like or not like? What should we discuss next time? Let us know via a YouTube comment, on social media, or by commenting on our Google doc!

~~~

Postgres FM is produced by:

• Michael Christofides, founder of pgMustard
• Nikolay Samokhvalov, founder of Postgres.ai

With special thanks to:

• Jessie Draws for the amazing artwork