Re: indexes on partitioned tables

From: Ron Johnson <ronljohnsonjr(at)gmail(dot)com>
To: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: indexes on partitioned tables
Date: 2024-07-11 12:39:18
Message-ID: CANzqJaBiONTEEvoCrANX5_99wGkjqHUeXxWE-NYgijm1y2auhg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

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.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Sathish Reddy 2024-07-11 13:13:35 Debizium configure from Kafka side
Previous Message Kashif Zeeshan 2024-07-11 08:24:26 Re: indexes on partitioned tables