TL;DR
Postgres 18 just dropped with a bundle of cool features—think native UUIDv7, an upgraded EXPLAIN module, composite index skip scans—and the crown jewel: true asynchronous I/O. In this episode of The Backend Engineering Show, Hussein breaks down sync vs. async I/O, recaps how Postgres 17 handled disk ops, then dives into Postgres 18’s new worker-based I/O and Linux io_uring support (with sync as a fallback).
He also teases what’s next: better backend-writer support, improved worker I/O methods, and direct I/O coming down the pipeline. If you want to wring every drop of performance from your database, this deep dive is your new best friend.
Watch on YouTube
Top comments (0)