| From: | yudhi s <learnerdatabase99(at)gmail(dot)com> |
|---|---|
| To: | Ron Johnson <ronljohnsonjr(at)gmail(dot)com> |
| Cc: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: error in trigger creation |
| Date: | 2024-04-21 20:15:05 |
| Message-ID: | CAEzWdqe23gOy3_0=kyNqvuA3Gj-qWad1nxTh+PSHZuqg7QYg2g@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Mon, 22 Apr, 2024, 1:34 am Ron Johnson, <ronljohnsonjr(at)gmail(dot)com> wrote:
> On Sun, Apr 21, 2024 at 2:58 PM yudhi s <learnerdatabase99(at)gmail(dot)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.
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Steve Baldwin | 2024-04-21 20:35:41 | Re: query multiple schemas |
| Previous Message | Norbert Sándor | 2024-04-21 20:12:22 | query multiple schemas |