On Tue, May 6, 2025 at 11:55:53AM -0400, Andres Freund wrote: > Hi, > > On 2025-05-05 15:07:01 -0400, Jonathan S. Katz wrote: > > ### Performance > > > > PostgreSQL 18 introduces an asynchronous I/O (AIO) subsystem using > > `io_uring` on Linux, which, when combined with direct I/O (DIO), lets > > PostgreSQL directly interface with storage interfaces. This new subsystem > > gives PostgreSQL the opportunity to maximize its usage of hardware transfer > > capacity, and this initial release supporting file system reads such as > > sequential scans, bitmap heap scans, and vacuums, with tests showing up to a > > 2-3x performance improvements. > > This isn't quite right: > > - AIO is usable on all platforms, it *optionally* can use io_uring on linux - > the default is to use AIO using worker processes
Actually, is AIO using worker processes new behavior or just a new implementation of our old behavior? I might need to point that out in the release notes. -- Bruce Momjian <br...@momjian.us> https://momjian.us EDB https://enterprisedb.com Do not let urgent matters crowd out time for investment in the future.
