TL;DR

Postgres 18 just dropped a bunch of goodies—UUIDv7, an “Over explain” module, composite-index skip-scans—and the headline feature: true asynchronous I/O. After walking through how sync vs async calls work (and demoing sync I/O in Postgres 17), the show digs into the two new I/O methods: a worker-based approach and the fancy Linux io_uring path (plus a fallback “sync” mode).

What’s Next?

They’ve nailed the basics, but there’s still work on backend writer support, beefing up the worker mode, plus adding direct I/O. In short: async I/O is live, but this is just the starting pistol for more performance gains in future releases.

Watch on YouTube