Postgres Pro
Downloads
Home   >   mailing lists

Re: indexes on partitioned tables - Mailing list pgsql-admin

From Wasim Devale
Subject Re: indexes on partitioned tables
Date
Msg-id CAB5fag6kq8Zz6x-KBDn_2NzLGDjbYBukmYV7_qELPq82GuVuBg@mail.gmail.com
Whole thread Raw
In response to Re: indexes on partitioned tables  (Ron Johnson <ronljohnsonjr@gmail.com>)
Responses Re: indexes on partitioned tables
Re: indexes on partitioned tables
List pgsql-admin
Tree view
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@gmail.com> wrote:
On Thu, Jul 11, 2024 at 4:16 AM Wasim Devale <wasimd60@gmail.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.

pgsql-admin by date:

Previous
From: Kashif Zeeshan
Date:
Subject: Re: Oracle to Postgres
Next
From: Muhammad Ikram
Date:
Subject: Re: indexes on partitioned tables