Postgres 18 rolls out some killer new goodies—think UUIDv7 support, an “Over Explain” module, composite index skip scans…and the headline act: true asynchronous IO. In a breezy run-through, Hussein breaks down sync vs. async IO, revisits how Postgres 17 handled disk ops, then dives into 18’s two async modes—worker threads that offload IO and the snappier io_uring on Linux.
We finish with a peek at the road ahead: bolstered backend‐writer support, better worker-mode performance and direct-IO options. If you’ve ever wondered how Postgres squeezes out every drop of disk throughput, this show’s a quick yet meaty trip through the latest IO revolution.
Watch on YouTube
Top comments (0)