Indexing Strategy for Partitioned Table in PostgreSQL 15.13

[Mahesh Shetty <maheshetty20@xxxxxxxxx>]

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