MIME-Version: 1.0
From: sud <suds1434@gmail.com>
Date: Mon, 19 Aug 2024 13:18:18 +0530
Message-ID: <CAD=mzVXZiDmAsTE1XiXnq1DFHM22uwnD8jckmBN_bTakk3u2AQ@mail.gmail.com>
Subject: Insert query performance
To: pgsql-general <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000e6c8a50620048812"
Archived-At: <https://www.postgresql.org/message-id/CAD%3DmzVXZiDmAsTE1XiXnq1DFHM22uwnD8jckmBN_bTakk3u2AQ%40mail.gmail.com>
Precedence: bulk

--000000000000e6c8a50620048812
Content-Type: text/plain; charset="UTF-8"

Hello All,

In a version 15.4 postgres database, Is it possible that , if we have two
big range partition tables with foreign key relationships between them,
insert into the child table can cause slowness if we don't have foreign key
index present in the child table? Basically it need to make sure the new
row already added to parent partition table or not.


And if there is any possible way(example query tracing etc) to get the
underlying system queries which gets triggered as part of the main insert
query? For example in above scenario, postgres must be executing some query
to check if the incoming  row to the child table already exists in the
parent table or not?


Regards

Sud

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

<div dir=3D"auto"><p dir=3D"ltr">Hello All,=C2=A0</p><p dir=3D"ltr">In a ve=
rsion 15.4 postgres database, <span style=3D"font-size:1em">Is</span> it po=
ssible that , if we have two big range partition tables with foreign key re=
lationships between them, insert into the child table can cause slowness if=
 we don&#39;t have foreign key index present in the child table? Basically =
it need to make sure the new row already added to parent partition table or=
 not.=C2=A0<br></p><p dir=3D"ltr">=C2=A0 <br>
<span style=3D"font-size:1em">And</span> if there is any possible way(examp=
le query tracing etc) to get the underlying system queries which gets trigg=
ered as part of the main insert query? For example in above scenario, postg=
res must be executing some query to check if the incoming=C2=A0 row to the =
child table already exists in the parent table or not?=C2=A0</p><p dir=3D"l=
tr"><br></p><p dir=3D"ltr">Regards</p><p dir=3D"ltr">Sud</p></div>

--000000000000e6c8a50620048812--