Request a Demo
Home   >   mailing lists

Re: About asynchronous I/O - Mailing list pgsql-admin

From Ron Johnson
Subject Re: About asynchronous I/O
Date
Msg-id CANzqJaAKAzYaGfPFLzt4ZZDs6sE5KGWuMmGWQ1oQYeC-wzHk_A@mail.gmail.com
Whole thread
In response to Re: About asynchronous I/O  (bertrand HARTWIG <hartwig.bertrand@gmail.com>)
Responses Re: About asynchronous I/O
List pgsql-admin
Tree view
On Tue, Jun 23, 2026 at 7:26 AM bertrand HARTWIG <hartwig.bertrand@gmail.com> wrote:

Hello,

The size of the database is clearly not important.

What matters are queries that are not already cached and that perform I/O.

With async I/O, you can see I/O performance improvements of up to 200%–300%. The higher the disk latency, the greater the gains you will notice.


So, not so useful on SSD/NVMe?
 

Regards,

Bertrand


Le 23 juin 2026 à 09:55, ek ek <livadidrive@gmail.com> a écrit :

Hello everyone,
Are any of you running PostgreSQL 18 on production environments sized between 1 to 3TB? Does the 'asynchronous I/O (AIO) subsystem' deliver a significant performance increase? Also, has anyone had the opportunity to benchmark it against v17?



--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!

pgsql-admin by date:

Previous
From: bertrand HARTWIG
Date:
Subject: Re: About asynchronous I/O
Next
From: bertrand HARTWIG
Date:
Subject: Re: About asynchronous I/O