Asynchronous IO in Postgres 18 — TL;DR

Postgres 18 just dropped with a bag of cool upgrades—think UUIDv7, an “over explain” module, composite index skip scans…and the headliner: built-in asynchronous IO. This episode walks you through the old synchronous IO world (Postgres 17) vs. the new async reality in 18, then unpacks each io_method (worker, io_uring, sync) with hands-on demos and benchmarks.

The deep dive doesn’t stop at “it’s faster.” You’ll see the real challenges of fitting async into Postgres’s architecture, plus upcoming goodies: backend‐writer support, direct IO, better worker tuning and more. Async IO is live, but it’s just getting started!

Watch on YouTube