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@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?
