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