Asynchronous IO in Postgres 18

Postgres 18 just dropped with a slew of goodies—think UUIDv7, the over-explain module, composite index skip scans and, most hyped of all, asynchronous IO support via both worker and io_uring modes. After a quick refresher on sync vs async calls and how Postgres 17 handled IO, the show tackles the trickiest bits of shoehorning async IO into Postgres’s architecture.

You’ll then get a tour of the new io_method options—worker, io_uring and yep, still good old sync—plus a peek at backend writer support, direct IO improvements and why the async IO saga is far from over.

Watch on YouTube