TL;DR
Postgres 18 brings a game-changer: true asynchronous I/O support alongside classic synchronous mode. Hussein Nasser kicks off by contrasting sync vs async calls, revisits Postgres 17’s disk I/O, then digs into the new io_method options—worker threads and Linux’s high-performance io_uring—showing how each handles reads/writes and why sync still hangs around as a fallback.
He also teases upcoming improvements—backend writer support, direct I/O tweaks and better worker-mode handling—so you can squeeze even more speed out of your database. Catch detailed demos from the 20-minute mark (worker vs io_uring) and stick around for a concise 37-minute wrap-up.
Watch on YouTube
Top comments (0)