{"type":"rich","version":"1.0","provider_name":"Transistor","provider_url":"https://transistor.fm","author_name":"Postgres FM","title":"Bloat","html":"","width":"100%","height":180,"duration":2177,"description":"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.\n \nHere are some links to things they mentioned:\nManaging your tuple graveyard (talk by Chelsea) https://www.youtube.com/watch?v=gAgbzvGT6ck\npgstattuple https://www.postgresql.org/docs/current/pgstattuple.html \npg_class https://www.postgresql.org/docs/current/catalog-pg-class.html \nBloat in PostgreSQL: a taxonomy (talk by Peter Geoghegan) https://youtube.com/watch?v=JDG4bMHxCH8 \nIt's Not You, It's Me: Breaking Up with Massive Tables via Partitioning (talk by Chelsea) https://youtube.com/watch?v=TafwSuLNxe8 \npg_repack https://github.com/reorg/pg_repack\npg_squeeze https://github.com/cybertec-postgresql/pg_squeeze \nVACUUM https://www.postgresql.org/docs/current/sql-vacuum.html\nautovacuum https://www.postgresql.org/docs/current/runtime-config-autovacuum.html \nCLUSTER https://www.postgresql.org/docs/current/sql-cluster.html \nHOT updates https://www.postgresql.org/docs/current/storage-hot.html \nOur episode on BUFFERS https://postgres.fm/episodes/buffers-by-default \nOur episode on TOAST https://postgres.fm/episodes/toast \nOur episode on index maintenance https://postgres.fm/episodes/index-maintenance \nChelsea's website: https://chelseadole.com/\n\n~~~\nWhat 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!\n\n~~~\nPostgres FM is produced by:\nMichael Christofides, founder of pgMustard\nNikolay Samokhvalov, founder of Postgres.ai\n\nWith special thanks to:\nJessie Draws for the amazing artwork ","thumbnail_url":"https://img.transistorcdn.com/NFbJlGhGV5mzIU1kM0iZ823A69pjZUNX40LszVO5LKI/rs:fill:0:0:1/w:400/h:400/q:60/mb:500000/aHR0cHM6Ly9pbWct/dXBsb2FkLXByb2R1/Y3Rpb24udHJhbnNp/c3Rvci5mbS9zaG93/LzMyMTQ3LzE3MTA3/OTEzODMtYXJ0d29y/ay5qcGc.webp","thumbnail_width":300,"thumbnail_height":300}