Disks

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 x.com/samokhvalov/status/1959468091035009245
• Postgres LISTEN/NOTIFY does not scale (blog post by Recall ai) recall.ai/blog/postgres-listen-notify-does-not…
• track_io_timing postgresql.org/docs/current/runtime-config-sta…
• pg_test_timing postgresql.org/docs/current/pgtesttiming.html
• PlanetScale for Postgres planetscale.com/blog/planetscale-for-postgres
• Out of disk episode postgres.fm/episodes/out-of-disk
• 100TB episode postgres.fm/episodes/to-100tb-and-beyond
• Latency Numbers Every Programmer Should Know gist.github.com/jboner/2841832
• Fio github.com/axboe/fio

~~~
What did you like or not like? What should we discuss next time? Let us know via a YouTube comment, on social media, (postgres.fm/people) or by commenting on our Google doc (docs.google.com/document/d/1PNGSn_d0A7gTR4C0p6…)!

~~~
Postgres FM is produced by:
• Michael Christofides, founder of pgMustard (pgmustard.com)
• Nikolay Samokhvalov, founder of Postgres.ai (postgres.ai)

With credit to:
• Jessie Draws for the elephant artwork