TL;DR

Postgres 18 just dropped with a slew of cool new toys—UUIDv7, an “over explain” module, composite index skip scans and, most buzzworthy of all, proper asynchronous I/O support.

In this episode you get a bite-sized primer on sync vs async calls, then a deep dive into Postgres’s new io_method options (worker threads, io_uring and the classic sync fallback), the challenges the team faced, and a sneak peek at what’s next (backend writer support, direct I/O and more refinements).

Watch on YouTube