Postgres 18 just dropped with a stack of new goodies—UUIDv7, an “Over explain” module, composite index skip scans and, the headline feature, true asynchronous IO. In this episode Hussein walks you through sync vs async calls, recaps how Postgres 17 handled IO synchronously, then unpacks the three io_method modes in 18 (worker threads, io_uring and the sync fallback) and what still needs work (backend writers, improving the worker mode, direct IO).
You’ll find handy timestamps to skip right to the meat (20:00 for async challenges, 23:00 for io_uring magic, 37:00 for the finale), plus links to Hussein’s courses, talks and tools if you want to dive even deeper into backend and database engineering. Enjoy!
Watch on YouTube
Top comments (0)