MIME-Version: 1.0
References: <CAEzWdqcimp5dnNOavaSkMCOKW_FVsKC2101g=dFsyjQ-9dA3uw@mail.gmail.com>
 <CAKFQuwa+jpZ-pucWc92OCYcwCnj7C_POg8k=5BvbPZyL97R-Jw@mail.gmail.com>
 <CAEzWdqfqr9e3OpFd5Nhqha3Ggm=+UJdWkgvo7dpAa3W99S2g5Q@mail.gmail.com>
 <CAKFQuwYu8w7BMX_9xEP1t5ULT7pV-qO1Yotn1qtdMuEpWCqhFg@mail.gmail.com>
 <2720974.1713710606@sss.pgh.pa.us> <CAEzWdqcs8OYtK9dWbev986FfNO0i9rGDvChZTti2xWL8HuXnbg@mail.gmail.com>
 <CAKFQuwawNxB_XEGhGiTmGT6efj8jB+g=a++3G9msmh2_R=OVoQ@mail.gmail.com>
 <CAEzWdqffAd3_hFjCdkpDFSpYQ6OxjRQzv4ZCnJQZwnCzvbq+-g@mail.gmail.com> <CANzqJaA-tMNpHhToYXyOxA=w4VVeFRWwRZGOOWergQzT222aAQ@mail.gmail.com>
In-Reply-To: <CANzqJaA-tMNpHhToYXyOxA=w4VVeFRWwRZGOOWergQzT222aAQ@mail.gmail.com>
From: yudhi s <learnerdatabase99@gmail.com>
Date: Mon, 22 Apr 2024 01:45:05 +0530
Message-ID: <CAEzWdqe23gOy3_0=kyNqvuA3Gj-qWad1nxTh+PSHZuqg7QYg2g@mail.gmail.com>
Subject: Re: error in trigger creation
To: Ron Johnson <ronljohnsonjr@gmail.com>
Cc: "David G. Johnston" <david.g.johnston@gmail.com>, Tom Lane <tgl@sss.pgh.pa.us>, 
	pgsql-general <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000b9e4380616a0fa58"
Archived-At: <https://www.postgresql.org/message-id/CAEzWdqe23gOy3_0%3DkyNqvuA3Gj-qWad1nxTh%2BPSHZuqg7QYg2g%40mail.gmail.com>
Precedence: bulk

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

On Mon, 22 Apr, 2024, 1:34 am Ron Johnson, <ronljohnsonjr@gmail.com> wrote:

> On Sun, Apr 21, 2024 at 2:58=E2=80=AFPM yudhi s <learnerdatabase99@gmail.=
com>
> wrote:
>
>> the partition drop from parent is taking longer as it scans all the
>> partitions of the child table
>>
>
> Does the relevant supporting index exist on the child table?
>

Yes all the child tables have foreign keys indexed.

 Again I don't want to divert the main topic(trigger creation) . I will
provide the exact test case how it puts exclusive lock and runs longer as
scans all child partitions (which must be using indexes though) but as the
number of partitions increase the time of drop partitions increases.

>

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

<div dir=3D"auto"><div><br><div class=3D"gmail_quote"><div dir=3D"ltr" clas=
s=3D"gmail_attr">On Mon, 22 Apr, 2024, 1:34 am Ron Johnson, &lt;<a href=3D"=
mailto:ronljohnsonjr@gmail.com">ronljohnsonjr@gmail.com</a>&gt; wrote:<br><=
/div><blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-le=
ft:1px #ccc solid;padding-left:1ex"><div dir=3D"ltr"><div dir=3D"ltr">On Su=
n, Apr 21, 2024 at 2:58=E2=80=AFPM yudhi s &lt;<a href=3D"mailto:learnerdat=
abase99@gmail.com" target=3D"_blank" rel=3D"noreferrer">learnerdatabase99@g=
mail.com</a>&gt; wrote:<br></div><div class=3D"gmail_quote"><blockquote cla=
ss=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid =
rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr"><div dir=3D"ltr">the pa=
rtition drop from parent is taking longer as it scans all the partitions of=
 the child table</div></div></blockquote><div>=C2=A0</div><div>Does the rel=
evant supporting index exist on the child table?</div></div></div></blockqu=
ote></div></div><div dir=3D"auto"><br></div><div dir=3D"auto">Yes all the c=
hild tables have foreign keys indexed.</div><div dir=3D"auto"><br></div><di=
v dir=3D"auto">=C2=A0Again I don&#39;t want to divert the main topic(trigge=
r creation) . I will provide the exact test case how it puts exclusive lock=
 and runs longer as scans all child partitions (which must be using indexes=
 though) but as the number of partitions increase the time of drop partitio=
ns increases.=C2=A0</div><div dir=3D"auto"><div class=3D"gmail_quote"><bloc=
kquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #cc=
c solid;padding-left:1ex">
</blockquote></div></div></div>

--000000000000b9e4380616a0fa58--