Asynchronous IO in Postgres 18
Postgres 18 finally brings true async IO to the table, with both worker-thread and io_uring modes joining the classic sync method. In this episode of The Backend Engineering Show, Hussein breaks down sync vs. async calls, revisits how PG17 handled IO, and dives into the nitty-gritty of io_method options—including direct IO support—and why they matter for performance.
Along the way you’ll also get a quick tour of other PG18 goodies like UUIDv7, the Over explain module, and composite index skip scans, plus a sneak peek at upcoming improvements for backend writers and worker IO methods.
Watch on YouTube
Top comments (0)