Re: Indexing Strategy for Partitioned Table in PostgreSQL 15.13

[Ron Johnson <ronljohnsonjr@xxxxxxxxx>]

On Mon, Aug 4, 2025 at 1:25 AM Mahesh Shetty <maheshetty20@xxxxxxxxx> 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?

Search for "CREATE INDEX ON ONLY" in https://www.postgresql.org/docs/15/ddl-partitioning.html

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!