Postgres 18 has arrived with a bunch of goodies—UUIDv7, an Over EXPLAIN module, composite index skip scans, and the big one: asynchronous IO via worker threads and io_uring. On The Backend Engineering Show, Hussein Nasser breaks down sync vs async calls, recaps Postgres 17’s IO model, and walks you through the io_method options (worker, io_uring, sync), plus upcoming improvements like backend-writer support and direct IO.
He even timestamps each chapter (from 0:00 intro to 37:00 wrap-up) and peppers the episode notes with bonus resources—courses on database engineering, OS fundamentals, Node.js internals, NGINX, Python backend, networking, troubleshooting and more—so you can dive deeper into whatever tickles your backend-fu.
Watch on YouTube
Top comments (0)