Postgres 18 just dropped with a slew of goodies—think native UUIDv7, an Over explain module, composite index skip scans, and, most importantly, revamped asynchronous I/O. In this episode, Hussein breaks down why async I/O matters, contrasting sync vs async calls, walks through Postgres 17’s sync approach, and then dives deep into PG18’s new io_method options: worker threads and cutting-edge io_uring (with a sync fallback, too).
But the async story doesn’t end here: the team’s already tackling backend writer support, refining worker I/O methods, and adding direct I/O capabilities. In short, async I/O in Postgres 18 is a game-changer that’s only getting started.
Watch on YouTube
Top comments (0)