From: bertrand HARTWIG <hartwig.bertrand@gmail.com>
Message-Id: <359C3FF2-C038-4237-A361-4DAEFA92C114@gmail.com>
Content-Type: multipart/alternative;
	boundary="Apple-Mail=_37BD700C-B6A3-47F6-97DD-930049163434"
Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3864.600.51.1.1\))
Subject: Re: About asynchronous I/O
Date: Tue, 23 Jun 2026 13:25:58 +0200
In-Reply-To: 
 <CALAkhNX_6OttLJa7X+0wA7vx+wVCUMHjNcgg+2fjw=_Z3CXTKg@mail.gmail.com>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
To: ek ek <livadidrive@gmail.com>
References: 
 <CALAkhNX_6OttLJa7X+0wA7vx+wVCUMHjNcgg+2fjw=_Z3CXTKg@mail.gmail.com>
Archived-At: 
 <https://www.postgresql.org/message-id/359C3FF2-C038-4237-A361-4DAEFA92C114%40gmail.com>
Precedence: bulk


--Apple-Mail=_37BD700C-B6A3-47F6-97DD-930049163434
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain;
	charset=utf-8

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%=E2=80=93300%. The higher the disk latency, the greater the gains =
you will notice.

Regards,

Bertrand


> Le 23 juin 2026 =C3=A0 09:55, ek ek <livadidrive@gmail.com> a =C3=A9crit=
 :
>=20
> 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?


--Apple-Mail=_37BD700C-B6A3-47F6-97DD-930049163434
Content-Transfer-Encoding: quoted-printable
Content-Type: text/html;
	charset=utf-8

<html aria-label=3D"message body"><head><meta http-equiv=3D"content-type" =
content=3D"text/html; charset=3Dutf-8"></head><body =
style=3D"overflow-wrap: break-word; -webkit-nbsp-mode: space; =
line-break: after-white-space;"><p class=3D"p1">Hello,</p><p =
class=3D"p1">The size of the database is clearly not important.</p><p =
class=3D"p1">What matters are queries that are not already cached and =
that perform I/O.</p><p class=3D"p1">With async I/O, you can see I/O =
performance improvements of up to 200%=E2=80=93300%. The higher the disk =
latency, the greater the gains you will notice.</p><p =
class=3D"p1">Regards,</p><p =
class=3D"p1">Bertrand</p><div><div><br><blockquote type=3D"cite"><div>Le =
23 juin 2026 =C3=A0 09:55, ek ek &lt;livadidrive@gmail.com&gt; a =C3=A9cri=
t :</div><br class=3D"Apple-interchange-newline"><div><div =
dir=3D"auto"><div dir=3D"auto">Hello everyone,</div><div dir=3D"auto">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?</div></div>
</div></blockquote></div><br></div></body></html>=

--Apple-Mail=_37BD700C-B6A3-47F6-97DD-930049163434--