Postgres 18 has landed, packing fresh goodies like UUIDv7, the Over-explain module, composite index skip scans—and the showstopper: asynchronous IO via worker threads and io_uring. In this Backend Engineering episode, Hussein Nasser demystifies sync vs async calls, revisits how Postgres 17 handled IO, and unveils how async IO supercharges performance in v18.
You’ll get a timestamped tour of each io_method (worker, io_uring, sync), the challenges overcome, and what’s coming next—backend writer support, direct IO, and more tweaks. If you’re into squeezing every last drop of speed from your database, this is the video for you!
Watch on YouTube
Top comments (0)