![Bloat](https://img.transistor.fm/XoJKBsIida2PbzEhDlUv56LV_igZ6S4xTONrCcJ6P7A/rs:fill:800:800:1/q:60/aHR0cHM6Ly9pbWct/dXBsb2FkLXByb2R1/Y3Rpb24udHJhbnNp/c3Rvci5mbS9zaG93/LzMyMTQ3LzE3MTA3/OTEzODMtYXJ0d29y/ay5qcGc.webp)
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:
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!
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
Creators and Guests
![Chelsea Dole](https://img.transistor.fm/z6ROfvdqSq9XBuho5mX31lCS1KdRn6sLmut6YwOpV7I/rs:fill:400:400:1/q:60/aHR0cHM6Ly9pbWct/dXBsb2FkLXByb2R1/Y3Rpb24udHJhbnNp/c3Rvci5mbS9wZXJz/b24vYWY4ZjAzOTIt/MzM3Yy00Y2M2LWFk/OTEtYzAxODhhM2U1/OTY5LzE3MDYxMTM1/MzMtaW1hZ2UuanBn.webp)
Guest
Chelsea Dole
Staff Software Engineer (and Tech Lead of the Data Storage Team) at Brex, and speaker at several prestigious Postgres conferences over the past couple years.