Indexing Strategy for Partitioned Table in PostgreSQL 15.13

From: Mahesh Shetty <maheshetty20(at)gmail(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Indexing Strategy for Partitioned Table in PostgreSQL 15.13
Date: 2025-08-04 05:25:00
Message-ID: CAJPiW+hfwGuGQ8fGKSB1-xU6O==eAhVGKrz_FHD3A0KVLv1KRg@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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?

Thanks in advance for your guidance.

Regards,

Mahesh

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message David G. Johnston 2025-08-04 05:35:13 Re: Indexing Strategy for Partitioned Table in PostgreSQL 15.13
Previous Message David G. Johnston 2025-08-04 04:47:48 Re: Vacuuming System DBs like postgres, template1