Asynchronous IO in Postgres 18 – TL;DR

Postgres 18 just landed with a handful of killer features—UUIDv7, an over-explain module, composite-index skip scans and, most buzzed about, true asynchronous IO. In this episode you’ll get a quick rundown of sync vs. async calls, see how Postgres 17 handled IO synchronously, then deep-dive into Postgres 18’s async implementations using worker threads and Linux’s io_uring (with a sync fallback).

Async IO in Postgres isn’t “done” yet: upcoming updates include backend writer support, refined worker IO strategies and direct-IO capabilities. If you geek out on DB internals or backend performance, this is your next must-watch deep dive.

Watch on YouTube