Postgres Pro
Downloads
Home   >   mailing lists

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

From Zaid Shabbir
Subject Re: indexes on partitioned tables
Date
Msg-id CABCJe_X1+HPauQYeDSnOSEx8kDz2jYxZV-Z_kcjD6_H1JM1RuA@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
List pgsql-admin
Tree view
Hello Ron,

Can you plz provide some details about your scenario like
Platform, PostgreSQL version, table details and queries you use.

Above information helps to identify the scenario and possible solution.


Thanks 


On Sat, 13 Jul 2024 at 12:36 AM, Ron Johnson <ronljohnsonjr@gmail.com> wrote:
"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@gmail.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@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: Ron Johnson
Date:
Subject: Re: indexes on partitioned tables
Next
From: Wasim Devale
Date:
Subject: Re: indexes on partitioned tables