Request a Demo
Home   >   mailing lists

Re: Indexing Strategy for Partitioned Table in PostgreSQL 15.13 - Mailing list pgsql-admin

From Ron Johnson
Subject Re: Indexing Strategy for Partitioned Table in PostgreSQL 15.13
Date
Msg-id CANzqJaAhS+dKz0yhz0UDSERfBVzbR1A8=oOtprjaQtPe4xB7gw@mail.gmail.com
Whole thread Raw
In response to Indexing Strategy for Partitioned Table in PostgreSQL 15.13  (Mahesh Shetty <maheshetty20@gmail.com>)
List pgsql-admin
Tree view
On Mon, Aug 4, 2025 at 1:25 AM Mahesh Shetty <maheshetty20@gmail.com> wrote:

Hello Team,

We’re running PostgreSQL version 15.13.

I have a large partitioned table with around 100 partitions, and we're planning to add an index to it. I'm a bit concerned about the potential impact and duration of the indexing process, and I’d appreciate your inputs on the following:

  1. If I run CREATE INDEX CONCURRENTLY on the parent table, will it automatically create indexes concurrently on all its partitions?

  2. Are there any recommended or more efficient approaches for indexing a heavily partitioned table that I should consider?


That'll tell you how to build indices in parallel and concurrently.

--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!

pgsql-admin by date:

Previous
From: "DINESH NAIR"
Date:
Subject: Re: Indexing Strategy for Partitioned Table in PostgreSQL 15.13
Next
From: Wasim Devale
Date:
Subject: Pg_logical