{"type":"rich","version":"1.0","provider_name":"Transistor","provider_url":"https://transistor.fm","author_name":"Postgres FM","title":"Out of disk","html":"","width":"100%","height":180,"duration":2606,"description":"Nikolay and Michael discuss Postgres running out of disk space — including what happens, what can cause it, how to recover, and most importantly, how to prevent it from happening in the first place.\n \nHere are some links to things they mentioned:\nDisk Full (docs) https://www.postgresql.org/docs/current/disk-full.html\npgcompacttable https://github.com/dataegret/pgcompacttable \nOur episode on massive deletes https://postgres.fm/episodes/massive-deletes \nGetting Rid of Data (slides from VLDB 2019 keynote by Tova Milo)\npg_tier https://github.com/tembo-io/pg_tier \nData tiering in Timescale Cloud https://docs.timescale.com/use-timescale/latest/data-tiering/ \nPostgres is Out of Disk and How to Recover (blog post by Elizabeth Christensen) https://www.crunchydata.com/blog/postgres-is-out-of-disk-and-how-to-recover-the-dos-and-donts \nmax_slot_wal_keep_size https://www.postgresql.org/docs/current/runtime-config-replication.html#GUC-MAX-SLOT-WAL-KEEP-SIZE \nOur episode on checkpoint tuning https://postgres.fm/episodes/wal-and-checkpoint-tuning \nAiven docs on full disk issues https://aiven.io/docs/products/postgresql/howto/prevent-full-disk  \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 elephant 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}