Postgres 18 just dropped with a bunch of goodies: UUIDv7 support, an “Over explain” module, smarter composite index skip scans, and—best of all—asynchronous IO modes! Hussein walks through the difference between sync and async calls, recaps Postgres 17’s sync-only IO, and then dives into the new io_method settings: worker threads, kernel-level io_uring, and the fallback sync mode.
He also teases future improvements—backend writer support, direct IO, and richer worker io_method tweaks—so async IO in Postgres is only getting started. Between the timestamps you’ll find clear demos, performance insights, and a roadmap for where Postgres storage is headed next.
Watch on YouTube
Top comments (0)