Re: indexes on partitioned tables

Поиск
Список
Период
Сортировка
От Kashif Zeeshan
Тема Re: indexes on partitioned tables
Дата
Msg-id CAAPsdhe-xssVJj+FhipgKq0UywEkZHsQmjKTe9YHwg+2SJ+CGA@mail.gmail.com
обсуждение исходный текст
Ответ на indexes on partitioned tables  (Wasim Devale <wasimd60@gmail.com>)
Список 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 по дате отправления: