MIME-Version: 1.0
From: veem v <veema0000@gmail.com>
Date: Tue, 17 Sep 2024 01:54:07 +0530
Message-ID: <CAB+=1TWZNvMhVthJ2iKs_Q4qBzMw-v_oaSz7HbFE_P_qC5jMFA@mail.gmail.com>
Subject: IO related waits
To: pgsql-general <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000008449970622425b02"
Archived-At: <https://www.postgresql.org/message-id/CAB%2B%3D1TWZNvMhVthJ2iKs_Q4qBzMw-v_oaSz7HbFE_P_qC5jMFA%40mail.gmail.com>
Precedence: bulk

--0000000000008449970622425b02
Content-Type: text/plain; charset="UTF-8"

Hi,
One of our application using RDS postgres. In one of our streaming
applications(using flink) which processes 100's of millions of transactions
each day, we are using row by row transaction processing for inserting data
into the postgres database and commit is performed for each row. We are
seeing heavy IO:XactSynch wait events during the data load and also high
overall response time.

Architecture team is suggesting to enable asynch io if possible, so that
the streaming client will not wait for the commit confirmation from the
database. So I want to understand , how asynch io can be enabled and if any
downsides of doing this?

Regards
Veem

--0000000000008449970622425b02
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"auto"><div dir=3D"auto">Hi,=C2=A0</div><div dir=3D"auto">One of=
 our application using RDS postgres. In one of our streaming applications(u=
sing flink) which processes 100&#39;s of millions of transactions each day,=
 we are using row by row transaction processing for inserting data into the=
 postgres database and commit is performed for each row. We are seeing heav=
y IO:XactSynch wait events during the data load and also high overall respo=
nse time.=C2=A0</div><div dir=3D"auto"><br></div><div dir=3D"auto">Architec=
ture team is suggesting to enable asynch io if possible, so that the stream=
ing client will not wait for the commit confirmation from the database. So =
I want to understand , how asynch io can be enabled and if any downsides of=
 doing this?=C2=A0</div><div dir=3D"auto"><br></div><div dir=3D"auto">Regar=
ds</div><div dir=3D"auto">Veem</div></div>

--0000000000008449970622425b02--