Asynchronous IO in Postgres 18
Postgres 18 rolls out a ton of goodies—think UUIDv7, composite index skip scans and an Over explain module—but steals the spotlight with true asynchronous I/O support. After a quick refresher on sync vs async calls and a look at Postgres 17’s purely synchronous model, the episode dives into two new io_methods (worker and io_uring), benchmarks, and how they stack up against classic sync I/O.
You’ll also catch a breakdown of remaining challenges (backend writer support, direct I/O tweaks) and a sneak peek at future enhancements. If you’ve been daydreaming of non-blocking disk ops in Postgres, this release is your cue to celebrate!
Watch on YouTube
Top comments (0)