Re: Indexing Strategy for Partitioned Table in PostgreSQL 15.13
| От | Ron Johnson |
|---|---|
| Тема | Re: Indexing Strategy for Partitioned Table in PostgreSQL 15.13 |
| Дата | |
| Msg-id | CANzqJaAhS+dKz0yhz0UDSERfBVzbR1A8=oOtprjaQtPe4xB7gw@mail.gmail.com обсуждение исходный текст |
| Ответ на | Indexing Strategy for Partitioned Table in PostgreSQL 15.13 (Mahesh Shetty <maheshetty20@gmail.com>) |
| Список | pgsql-admin |
On Mon, Aug 4, 2025 at 1:25 AM Mahesh Shetty <maheshetty20@gmail.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:
If I run
CREATE INDEX CONCURRENTLYon the parent table, will it automatically create indexes concurrently on all its partitions?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!
В списке pgsql-admin по дате отправления: