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.
Regards,
Bertrand
> Le 23 juin 2026 à 09:55, ek ek <livadidrive(at)gmail(dot)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?