Asynchronous IO in Postgres 18
Postgres 18 just dropped with some neat new toys—UUIDv7, the Over Explain module, composite index skip scans, and the big one: asynchronous IO. In our latest Backend Engineering Show, Hussein breaks down sync vs async calls, revisits Postgres 17’s sync-only approach, and walks you step-by-step through Postgres 18’s async IO modes (worker, io_uring, plus the classic sync fallback) and hints at upcoming improvements like direct IO and better backend writer support.
Highlights & Chapters
- 1:30 Sync vs Async calls
- 10:00 Recap: Postgres 17 sync IO
- 17:20 Async IO challenges in Postgres 18
- 20:00 io_method=worker | 23:00 io_uring | 29:30 sync
- 31:08 What’s next: more async tweaks & direct IO support
Watch on YouTube
Top comments (0)