Postgres 18 lands with some flashy new toys—UUIDv7, the Over Explain module and composite-index skip scans—but the real headliner is built-in asynchronous I/O. Hussein kicks off with a quick primer on sync vs async calls, then dives into how Postgres 18 actually pulls it off under the hood, unveiling two io_method modes (worker threads and the speed-demon io_uring) alongside the good old synchronous fallback.
Along the way you’ll see how Postgres 17 handled I/O, the trickiest challenges the team cracked to enable async support, and a sneak peek at what’s still on the roadmap (better backend-writer workflows, direct I/O, worker optimizations, etc.). It’s a hands-on, no-fluff tour for anyone hungry to see how modern databases squeeze every drop of performance.
Watch on YouTube
Top comments (0)