Re: PostgreSQL 18 Beta 1 release announcement draft

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  <bruce@momjian.us>        https://momjian.us
  EDB                                      https://enterprisedb.com

  Do not let urgent matters crowd out time for investment in the future.