From: | Wasim Devale <wasimd60(at)gmail(dot)com> |
---|---|
To: | Ron Johnson <ronljohnsonjr(at)gmail(dot)com> |
Cc: | Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org> |
Subject: | Re: indexes on partitioned tables |
Date: | 2024-07-12 05:31:04 |
Message-ID: | CAB5fag6kq8Zz6x-KBDn_2NzLGDjbYBukmYV7_qELPq82GuVuBg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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 | Muhammad Ikram | 2024-07-12 05:39:38 | Re: indexes on partitioned tables |
Previous Message | Kashif Zeeshan | 2024-07-12 04:17:48 | Re: Oracle to Postgres |