MIME-Version: 1.0
References: <CAD=mzVXZiDmAsTE1XiXnq1DFHM22uwnD8jckmBN_bTakk3u2AQ@mail.gmail.com>
In-Reply-To: <CAD=mzVXZiDmAsTE1XiXnq1DFHM22uwnD8jckmBN_bTakk3u2AQ@mail.gmail.com>
From: Muhammad Ikram <mmikram@gmail.com>
Date: Mon, 19 Aug 2024 12:55:32 +0500
Message-ID: <CAGeimVqF+2vAwbMRznGvbAWs=1u+4zLkZ11irO3yuBP6sLmPow@mail.gmail.com>
Subject: Re: Insert query performance
To: sud <suds1434@gmail.com>
Cc: pgsql-general <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000002a3012062004a356"
Archived-At: <https://www.postgresql.org/message-id/CAGeimVqF%2B2vAwbMRznGvbAWs%3D1u%2B4zLkZ11irO3yuBP6sLmPow%40mail.gmail.com>
Precedence: bulk

--0000000000002a3012062004a356
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Hi Sud,

Please make following change in your postgresql.conf file

log_statement =3D 'all'


Regards,
Ikram


On Mon, Aug 19, 2024 at 12:48=E2=80=AFPM sud <suds1434@gmail.com> wrote:

> 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 k=
ey
> 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 que=
ry
> to check if the incoming  row to the child table already exists in the
> parent table or not?
>
>
> Regards
>
> Sud
>


--=20
Muhammad Ikram

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

<div dir=3D"ltr">Hi Sud,<div><br></div><div>Please make following change in=
 your postgresql.conf file</div><div><br></div><div>log_statement =3D &#39;=
all&#39;=C2=A0<br></div><div><br></div><div><br></div><div>Regards,</div><d=
iv>Ikram</div><div><br></div></div><br><div class=3D"gmail_quote"><div dir=
=3D"ltr" class=3D"gmail_attr">On Mon, Aug 19, 2024 at 12:48=E2=80=AFPM sud =
&lt;<a href=3D"mailto:suds1434@gmail.com">suds1434@gmail.com</a>&gt; wrote:=
<br></div><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8=
ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir=3D"aut=
o"><p dir=3D"ltr">Hello All,=C2=A0</p><p dir=3D"ltr">In a version 15.4 post=
gres database, <span style=3D"font-size:1em">Is</span> it possible that , i=
f we have two big range partition tables with foreign key relationships bet=
ween them, insert into the child table can cause slowness if we don&#39;t h=
ave 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>
</blockquote></div><br clear=3D"all"><div><br></div><span class=3D"gmail_si=
gnature_prefix">-- </span><br><div dir=3D"ltr" class=3D"gmail_signature"><d=
iv dir=3D"ltr"><div>Muhammad Ikram<br><br></div></div></div>

--0000000000002a3012062004a356--