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

From Kashif Zeeshan
Subject Re: indexes on partitioned tables
Date
Msg-id CAAPsdhe-xssVJj+FhipgKq0UywEkZHsQmjKTe9YHwg+2SJ+CGA@mail.gmail.com
Whole thread Raw
In response to indexes on partitioned tables  (Wasim Devale <wasimd60@gmail.com>)
List pgsql-admin
Hi

When you create an index on Partition table then the index is created for all the Partitions so when you re-index then you need to re-index each partition separately.

Regards
Kashif Zeeshan

On Thu, Jul 11, 2024 at 1:16 PM 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?

Thanks,
Wasim 

pgsql-admin by date:

Previous
From: Wasim Devale
Date:
Subject: indexes on partitioned tables
Next
From: Ron Johnson
Date:
Subject: Re: indexes on partitioned tables