TL;DR

Postgres 18 just dropped with a heap of new toys—UUIDv7 support, an Over-EXPLAIN module and composite-index skip scans—and the star of the show: asynchronous I/O. After revisiting the pains of synchronous I/O in Postgres 17, Hussein walks us through the design challenges and shows how Postgres 18 tackles them with three I/O modes: the classic sync method, a worker-based async API and the shiny new io_uring path.

Along the way you’ll catch bite-size demos (with timestamps!) on setting up each mode, plus a peek at what’s still cooking: backend writer support, direct I/O, more fine-tuning of worker I/O and—spoiler—async isn’t finished yet. Perfect for anyone wanting a quick but lively guide to the async I/O revolution in Postgres 18.

Watch on YouTube