Postgres 18 just dropped with some killer upgrades—think UUIDv7, a beefed-up EXPLAIN module and composite index skip scans—but the star of the show is the long-awaited asynchronous I/O revamp. Hussein Nasser walks us through sync vs. async calls, revisits Postgres 17’s I/O model, then dives into the new io_method=worker and io_uring modes, plus direct I/O and backend writers.
Along the way he highlights the engineering hurdles Postgres faced, current limitations and the roadmap for making async I/O even smoother. If you care about squeezing every drop of performance out of your database, this episode is a must-watch.
Watch on YouTube
Top comments (0)