TL;DR

Postgres 18 just landed with a ton of fresh toys—think native UUIDv7 support, an “over” explain module for deep query introspection, composite-index skip scans, and the big headline: true asynchronous I/O. In this episode, Hussein breaks down sync vs async calls, revisits Postgres 17’s I/O model, and then dives into Postgres 18’s new async I/O layers (worker threads and io_uring), plus the ability to fall back to sync when needed.

He also teases what’s next—better backend writer support, direct I/O, and more fine-tuned io_method tweaks—and wraps up with a quick recap at the end.

Watch on YouTube