Asynchronous IO in Postgres 18
Postgres 18 just landed with a bunch of cool additions—UUIDv7 support, Over explain, composite index skip scans—and the big headline: true asynchronous IO. The episode kicks off by breaking down sync vs async calls, revisits how Postgres 17 handled disk access, then dives deep into two new IO methods: the classic worker queue and the slick, low-latency io_uring approach (with a sync fallback for good measure).
Along the way you’ll discover the hurdles the team had to overcome, tease out upcoming goodies (think direct IO and backend writer support), and wrap up with a clear roadmap for where async IO is headed next. It’s your one-stop crash course in squeezing every last drop of performance out of Postgres.
Watch on YouTube
Top comments (0)