From: | Ron Johnson <ronljohnsonjr(at)gmail(dot)com> |
---|---|
To: | Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org> |
Subject: | Re: indexes on partitioned tables |
Date: | 2024-07-12 19:36:07 |
Message-ID: | CANzqJaBM-waiBM_0zmwEUKhJ-LoRu1Wat3QJJAm4y5zHE53Sdg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
"and I can see indexes are created on child tables too."
That's what's supposed to happen.
As for errors... you haven't shown us any actual errors, only vague
descriptions.
On Fri, Jul 12, 2024 at 1:31 AM Wasim Devale <wasimd60(at)gmail(dot)com> wrote:
> Hi Ron
>
> I created the indexes on the parent table globally and ran the create
> script with partitioned tables script, the parent table with child tables
> are created and I can see indexes are created on child tables too.
>
> Then I inserted data from existing table.
>
> Thanks,
> Wasim
>
> On Thu, 11 Jul, 2024, 6:09 pm Ron Johnson, <ronljohnsonjr(at)gmail(dot)com>
> wrote:
>
>> On Thu, Jul 11, 2024 at 4:16 AM Wasim Devale <wasimd60(at)gmail(dot)com> wrote:
>>
>>> Hi All,
>>>
>>> I have partitioned a table and levied indexes on it but when I do
>>> maintenance activities like reindexing it's not happening and the error is
>>> index not present on the partitioned table.
>>>
>>> Please highlight some points on it, Is I am missing something?
>>>
>>
>> Show us the code. Maybe you're doing "CREATE INDEX ... ON *ONLY* ...;"
>> Or something else; we don't know, since your question is light on details.
>>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Zaid Shabbir | 2024-07-12 19:41:32 | Re: indexes on partitioned tables |
Previous Message | Ron Johnson | 2024-07-12 13:41:42 | Re: Oracle to Postgres |