Postgres 18 has been released with many exciting features such as UUIDv7, Over explain module, composite index skip scans, and the most anticipated asynchronous IO with worker and io_uring mode which I uncover in this show. Hope you enjoy it0:00 Intro1:30 Synchronous vs Asynchronous calls3:00 Synchronous IO6:30 Asynchronous IO10:00 Postgres 17 synchronous io 17:20 The challenge of Async IO in Postgres 1820:00 io_method worker23:00 io_method io_uring29:30 io_method sync 31:08 Async IO isn’t done! 31:30 Support for backend writers32:36 Improve worker io_method33:00 direct io support 37:00 Summary
Podzilla Summary coming soon
Sign up to get notified when the full AI-powered summary is ready.
Free forever for up to 3 podcasts. No credit card required.
Listen to This Episode
More from The Backend Engineering Show with Hussein Nasser
My new book - Root cause, Stories from two decades of backend bugs
5 Backend Design Patterns for Managing Threads and Sockets
Page Tables
CPU and Kernel Page Faults
Get summaries like this every morning.
Free AI-powered recaps of The Backend Engineering Show with Hussein Nasser and your other favorite podcasts, delivered to your inbox.
Free forever for up to 3 podcasts. No credit card required.