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