TL;DR

Postgres 18 just dropped with a bunch of neat upgrades—think UUIDv7, improved EXPLAIN output, composite index skip scans… and best of all, native asynchronous I/O. After three years of wrestling with sync vs async calls, you can now pick between worker and super-fast io_uring modes (plus a fallback sync mode), cutting down wait times for disk ops.

The show also teases what’s next: better backend-writer support, more polish on worker I/O, and direct-I/O enhancements. If you’ve been itching for truly nonblocking Postgres performance, this release is the one to watch!

Watch on YouTube