Asynchronous I/O finally lands in Postgres 18 alongside other goodies like UUIDv7, an “over explain” module and composite index skip scans. In this Backend Engineering Show episode, Hussein Nasser breaks down sync vs. async calls, revisits Postgres 17’s synchronous I/O, then digs into the new io_method options—worker threads, Linux io_uring, and the fallback sync mode—highlighting their design, trade-offs and performance gains.
He also covers what’s next: backend writer support improvements, direct I/O, and further optimizations to make Postgres’s async I/O rock-solid. Whether you’re tuning a high-throughput database or just curious about low-level I/O magic, this deep dive is well worth your time.
Watch on YouTube
Top comments (0)