Scale Forem

Scale YouTube
Scale YouTube

Posted on

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

TL;DR

Postgres 18 just dropped with killer new toys—think UUIDv7, a revamped EXPLAIN module and composite index skip scans—but the real headliner is built-in asynchronous IO. Hussein kicks things off by breaking down sync vs async calls, revisits how Postgres 17 tackled IO, then lays out why non-blocking disk access has been such a beast to tame.

In the main event you get a hands-on tour of the three io_methods—worker, io_uring and the classic sync fallback—alongside a peek at direct IO, backend writer support and upcoming tweaks. If you’ve ever wanted your database to stop waiting on disks, this episode is pure gold.

Watch on YouTube

Top comments (0)