Hussein Nasser: Asynchronous IO in Postgres 18 | The Backend Engineering Show

Postgres 18 Highlights

Postgres 18 just dropped with a bunch of goodies—think native UUIDv7 support, an Over explain module and composite index skip scans—but the real party trick is its new asynchronous I/O modes. In this episode of The Backend Engineering Show, Hussein walks us through sync vs. async I/O, digs into Postgres 17’s limitations, then shows off the fresh io_method=worker and io_method=io_uring options (plus the ever-faithful sync) and teases future improvements like direct I/O and better backend writer support.

Watch on YouTube