Request a Demo
Home   >   mailing lists

Indexing Strategy for Partitioned Table in PostgreSQL 15.13 - Mailing list pgsql-admin

From Mahesh Shetty
Subject Indexing Strategy for Partitioned Table in PostgreSQL 15.13
Date
Msg-id CAJPiW+hfwGuGQ8fGKSB1-xU6O==eAhVGKrz_FHD3A0KVLv1KRg@mail.gmail.com
Whole thread Raw
Responses Re: Indexing Strategy for Partitioned Table in PostgreSQL 15.13
Re: Indexing Strategy for Partitioned Table in PostgreSQL 15.13
List pgsql-admin
Tree view

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

pgsql-admin by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Vacuuming System DBs like postgres, template1
Next
From: "David G. Johnston"
Date:
Subject: Re: Indexing Strategy for Partitioned Table in PostgreSQL 15.13