Re: Indexing Strategy for Partitioned Table in PostgreSQL 15.13

On Mon, Aug 4, 2025 at 1:25 AM Mahesh Shetty <maheshetty20(at)gmail(dot)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?
>
> 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!