Asynchronous IO in Postgres 18 TL;DR

Postgres 18 ships with cool new toys—UUIDv7, an overhauled EXPLAIN module, composite index skip scans—and the long-awaited asynchronous IO support via worker and io_uring modes. Hussein Nasser breaks down how async differs from sync IO, dives into io_method options (worker, io_uring, sync), and hints at what’s next: direct IO, backend writer support, and more optimizations.

Watch on YouTube