public inbox for [email protected]  

help / color / mirror / Atom feed

From: Mahesh Shetty <[email protected]>
To: [email protected]
Subject: Indexing Strategy for Partitioned Table in PostgreSQL 15.13
Date: Mon, 4 Aug 2025 10:55:00 +0530
Message-ID: <CAJPiW+hfwGuGQ8fGKSB1-xU6O==eAhVGKrz_FHD3A0KVLv1KRg@mail.gmail.com> (raw)

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

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: Indexing Strategy for Partitioned Table in PostgreSQL 15.13
  In-Reply-To: <CAJPiW+hfwGuGQ8fGKSB1-xU6O==eAhVGKrz_FHD3A0KVLv1KRg@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox