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 …

databases postgres postgresql sql technology