Postgres 18 has been released with many exciting features such as UUIDv7, Over explain module, composite index skip scans, and the most anticipated asynchronous IO with worker and io_uring mode which I uncover in this show. Hope you enjoy it
0:00 Intro
1:30 Synchronous vs Asynchronous calls
3:00 Synchronous IO
6:30 Asynchronous IO
10:00 Postgres 17 synchronous io
17:20 The challenge of Async IO in Postgres 18
20:00 io_method worker23:00
io_method io_uring
29:30 io_method sync
31:08 Async IO isn’t done! 3
1:30 Support for backend writers
32:36 Improve worker io_method
33:00 direct io support
37:00 Summary