Disks

Episode 156

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/1959468091035009245
Postgres LISTEN/NOTIFY does not scale (blog post by Recall ai) https://www.recall.ai/blog/postgres-listen-notify-does-not-scale
track_io_timing https://www.postgresql.org/docs/current/runtime-config-statistics.html#GUC-TRACK-IO-TIMING
pg_test_timing https://www.postgresql.org/docs/current/pgtesttiming.html
PlanetScale for Postgres https://planetscale.com/blog/planetscale-for-postgres
Out of disk episode https://postgres.fm/episodes/out-of-disk
100TB episode https://postgres.fm/episodes/to-100tb-and-beyond
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 via a YouTube comment, on social media, or by commenting on our Google doc!

~~~

Postgres FM is produced by:

Michael Christofides, founder of pgMustard
Nikolay Samokhvalov, founder of Postgres.ai

With credit to:

Jessie Draws for the elephant artwork

Published on 3 weeks ago

Podcast Episode Details

Disks