Re: Asynchronous and "direct" IO support for PostgreSQL.

Andres Freund <andres@anarazel.de>

From: Andres Freund <andres@anarazel.de>
To: Michael Paquier <michael@paquier.xyz>
Cc: pgsql-hackers@postgresql.org, Thomas Munro <thomas.munro@gmail.com>, David Rowley <dgrowleyml@gmail.com>, Melanie Plageman <melanieplageman@gmail.com>
Date: 2022-11-09T03:02:48Z
Lists: pgsql-hackers
Hi,

On 2022-10-12 14:45:26 +0900, Michael Paquier wrote:
> On Tue, Aug 31, 2021 at 10:56:59PM -0700, Andres Freund wrote:
> > I've attached the code for posterity, but the series is large enough that I
> > don't think it makes sense to do that all that often... The code is at
> > https://github.com/anarazel/postgres/tree/aio
> 
> I don't know what's the exact status here, but as there has been no
> activity for the past five months, I have just marked the entry as RwF
> for now.

We're trying to get a number of smaller prerequisite patches merged this CF
(aligned alloc, direction IO, dclist, bulk relation extension, ...). Once
that's done I'm planning to send out a new version of the (large) remainder of
the changes.

Greetings,

Andres Freund



Commits

  1. aio: Add README.md explaining higher level design

  2. bufmgr: Use AIO in StartReadBuffers()

  3. bufmgr: Implement AIO read support

  4. aio: Implement support for reads in smgr/md/fd

  5. aio: Add io_method=io_uring

  6. aio: Add io_method=worker

  7. aio: Infrastructure for io_method=worker

  8. aio: Add core asynchronous I/O infrastructure