Hussein dives into everything new in Postgres 18—from fresh toys like UUIDv7, the Over Explain module and composite-index skip scans to the long-awaited asynchronous I/O. After a quick recap of sync vs async calls and how Postgres 17 handled I/O, he unpacks Postgres 18’s new io_method options: worker threads, io_uring and a sync fallback, plus the tricky bits that made async I/O so challenging to pull off.
He wraps up with a sneak peek at what’s next—backend writers getting async love, beefed-up worker performance, direct I/O support—and why async I/O in Postgres is still very much “a work in progress.”
Watch on YouTube
Top comments (0)