Re: indexes on partitioned tables

From: Kashif Zeeshan <kashi(dot)zeeshan(at)gmail(dot)com>
To: Wasim Devale <wasimd60(at)gmail(dot)com>
Cc: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>, pgsql-admin(at)postgresql(dot)org
Subject: Re: indexes on partitioned tables
Date: 2024-07-11 08:24:26
Message-ID: CAAPsdhe-xssVJj+FhipgKq0UywEkZHsQmjKTe9YHwg+2SJ+CGA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(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?
>
> Thanks,
> Wasim
>

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Ron Johnson 2024-07-11 12:39:18 Re: indexes on partitioned tables
Previous Message Wasim Devale 2024-07-11 08:15:38 indexes on partitioned tables