Asynchronous IO in Postgres 18

Postgres 18 just landed with a bunch of fresh toys—UUIDv7, an Over explain module, composite‐index skip scans—and the headliner: true asynchronous IO using new worker and io_uring modes. The video kicks off by comparing sync vs. async calls, revisits Postgres 17’s purely synchronous IO, then digs into why plugging async IO into Postgres was such a beast.

You’ll see deep dives on each io_method (worker, io_uring, sync), hear about upcoming backend‐writer and direct IO support, and catch a quick “what’s next” roadmap. Perfect for anyone hungry to juice more performance out of their database.

Watch on YouTube