Disks cover art

Disks

Disks

Listen for free

View show details

About this listen

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
No reviews yet
In the spirit of reconciliation, Audible acknowledges the Traditional Custodians of country throughout Australia and their connections to land, sea and community. We pay our respect to their elders past and present and extend that respect to all Aboriginal and Torres Strait Islander peoples today.