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

More episodes of The Backend Engineering Show with Hussein Nasser

• New Book: Root cause · 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
• Graceful shutdown in HTTP · October 17, 2025 · 26 min

Explore listener stats, chart rankings, contacts and more on the The Backend Engineering Show with Hussein Nasser podcast page.