<description>&lt;p&gt;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&lt;/p&gt;&lt;p&gt;&lt;br /&gt;&lt;/p&gt;&lt;p&gt;&lt;br /&gt;0:00 Intro&lt;/p&gt;&lt;p&gt;1:30 Synchronous vs Asynchronous calls&lt;/p&gt;&lt;p&gt;3:00 Synchronous IO&lt;/p&gt;&lt;p&gt;6:30 Asynchronous IO&lt;/p&gt;&lt;p&gt;10:00 Postgres 17 synchronous io &lt;/p&gt;&lt;p&gt;17:20 The challenge of Async IO in Postgres 18&lt;/p&gt;&lt;p&gt;20:00 io_method worker23:00&lt;/p&gt;&lt;p&gt; io_method io_uring&lt;/p&gt;&lt;p&gt;29:30 io_method sync &lt;/p&gt;&lt;p&gt;31:08 Async IO isn’t done! 3&lt;/p&gt;&lt;p&gt;1:30 Support for backend writers&lt;/p&gt;&lt;p&gt;32:36 Improve worker io_method&lt;/p&gt;&lt;p&gt;33:00 direct io support &lt;/p&gt;&lt;p&gt;37:00 Summary &lt;br /&gt;&lt;/p&gt;
</description>

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 Intro1:30 Synchronous vs Asynchronous calls3:00 Synchronous IO6:30 Asynchronous IO10:00 Postgres 17 synchronous io 17:20 The challenge of Async IO in Postgres 1820:00 io_method worker23:00 io_method io_uring29:30 io_method sync 31:08 Async IO isn’t done! 31:30 Support for backend writers32:36 Improve worker io_method33:00 direct io support 37:00 Summary

The Backend Engineering Show with Hussein Nasser

Postgres 18 gets Async IO

Postgres 18 gets Async IO

Description