[ 🇬🇧_🇺🇸 Check out the subtitles – we now edit them, ChatGPT+manually! You can also try YouTube's auto-translation of them from English to your language; try it and share it with people interested in Postgres!]

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)    • Understanding & Managing Postgres Tab...  
* pgstattuple https://www.postgresql.org/docs/curre...
* pg_class https://www.postgresql.org/docs/curre...
* Bloat in PostgreSQL: a taxonomy (talk by Peter Geoghegan)    • Bloat in PostgreSQL: a taxonomy  
* It's Not You, It's Me: Breaking Up with Massive Tables via Partitioning (talk by Chelsea)    • Chelsea Dole: It's Not You, It's Me: ...  
* pg_repack https://github.com/reorg/pg_repack
* pg_squeeze https://github.com/cybertec-postgresq...
* VACUUM https://www.postgresql.org/docs/curre...
* autovacuum https://www.postgresql.org/docs/curre...
* CLUSTER https://www.postgresql.org/docs/curre...
* HOT updates https://www.postgresql.org/docs/curre...
* Our episode on BUFFERS https://postgres.fm/episodes/buffers-...
* Our episode on TOAST https://postgres.fm/episodes/toast
* Our episode on index maintenance https://postgres.fm/episodes/index-ma...
* Chelsea's website https://chelseadole.com/

~~~


What did you like or not like? What should we discuss next time? Let us know in the comments, on social media (https://postgres.fm/people), or on our shared Google doc (https://docs.google.com/document/d/1P...)


~~~


Postgres FM is produced by:
- Nikolay Samokhvalov, founder of Postgres.ai https://postgres.ai/
- Michael Christofides, founder of pgMustard https://pgmustard.com/

With special thanks to
- Jessie Draws for the artwork https://jessiedraws.com/