Disks | Postgres.FM 156 | #PostgreSQL #Postgres podcast

[ 🇬🇧_🇺🇸 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!] Nik and Michael discuss disks in relation to Postgres — why they matter, how saturation can happen, some modern nuances, and how to prepare to avoid issues. Here are some links to things they mentioned: Nik’s tweet demonstrating a NOTIFY hot spot https://x.com/samokhvalov/status/1959... Postgres LISTEN/NOTIFY does not scale (blog post by Recall ai) https://www.recall.ai/blog/postgres-l... track_io_timing https://www.postgresql.org/docs/curre... pg_test_timing https://www.postgresql.org/docs/curre... PlanetScale for Postgres https://planetscale.com/blog/planetsc... Out of disk episode https://postgres.fm/episodes/out-of-disk 100TB episode https://postgres.fm/episodes/to-100tb... Latency Numbers Every Programmer Should Know https://gist.github.com/jboner/2841832 Fio https://github.com/axboe/fio ~~~ What did you like or not like? What should we discuss next time? Let us know in the comments, or by tweeting us on @postgresfm   / postgresfm  , @samokhvalov   / samokhvalov   and @michristofides   / michristofides   ~~~ Postgres FM is produced by: Nikolay Samokhvalov, founder of Postgres.ai https://postgres.ai/ Michael Christofides, founder of pgMustard https://pgmustard.com/ ~~~ This is the video version. Check out https://postgres.fm to subscribe to the audio-only version, to see the transcript, guest profiles, and more.