Postgres 18 gets Async IO
From The Backend Engineering Show with Hussein Nasser by Hussein Nasser
October 3, 2025 · 41 min
About this episode
Hussein Nasser discusses the new features of Postgres 18, focusing on asynchronous IO and its implications.
Postgres 18 has been released with many exciting features such as UUIDv7, Over explain module, composite index skip scans, and the most anticipated asynchronous IO with worker and io_uring mode which I uncover in this show. Hope you enjoy it 0:00 Intro 1:30 Synchronous vs Asynchronous calls 3:00 Synchronous IO 6:30 Asynchronous IO 10:00 Postgres 17 synchronous io 17:20 The challenge of Async IO in Postgres 18 20:00 io_method worker23:00 io_method io_uring 29:30 io_method sync 31:08 Async IO isn’t done! 3 1:30 Support for backend writers 32:36 Improve worker io_method 33:00 direct io support 37:00 Summary
People in this episode
Host: Hussein Nasser
Topics covered
- Postgres 18 features
- Asynchronous IO
- Synchronous vs Asynchronous calls
- Database performance
- Postgres improvements
Keywords
- Postgres 18
- Async IO
- Synchronous IO
- UUIDv7
- database performance
- io_uring
- worker
Mentioned in this episode
Products: Postgres 18, Postgres 17
More episodes of The Backend Engineering Show with Hussein Nasser
- Don't let AI rob you · June 8, 2026 · 32 min
- My new book - Root cause, Stories from two decades of backend bugs · April 15, 2026 · 10 min
- 5 Backend Design Patterns for Managing Threads and Sockets · January 19, 2026 · 46 min
- Page Tables · December 15, 2025 · 47 min
- CPU and Kernel Page Faults · November 24, 2025 · 49 min
- Amazon US-EAST-1 Outage in Details · October 31, 2025 · 24 min
Explore listener stats, chart rankings, contacts and more on the The Backend Engineering Show with Hussein Nasser podcast page.