public inbox for [email protected]  

help / color / mirror / Atom feed

From: David G. Johnston <[email protected]>
To: Mahesh Shetty <[email protected]>
Cc: [email protected] <[email protected]>
Subject: Re: Indexing Strategy for Partitioned Table in PostgreSQL 15.13
Date: Sun, 3 Aug 2025 22:35:13 -0700
Message-ID: <CAKFQuwanhAmgSdh4ou=grR0FiwnM4dEojELmtHTmkyjtJEx5sw@mail.gmail.com> (raw)
In-Reply-To: <CAJPiW+hfwGuGQ8fGKSB1-xU6O==eAhVGKrz_FHD3A0KVLv1KRg@mail.gmail.com>
References: <CAJPiW+hfwGuGQ8fGKSB1-xU6O==eAhVGKrz_FHD3A0KVLv1KRg@mail.gmail.com>

On Sunday, August 3, 2025, Mahesh Shetty <[email protected]> wrote:
>
> 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,
>

It will end very quickly…

> 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?
>
> Sometimes it’s best to just try (I didn’t though)…but the answer is
explicitly documented (see create index)

Concurrent builds for indexes on partitioned tables are currently not
supported. However, you may concurrently build the index on each partition
individually and then finally create the partitioned index non-concurrently
in order to reduce the time where writes to the partitioned table will be
locked out. In this case, building the partitioned index is a metadata only
operation.

David J.

view thread (4+ messages)  latest in thread

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], [email protected]
  Subject: Re: Indexing Strategy for Partitioned Table in PostgreSQL 15.13
  In-Reply-To: <CAKFQuwanhAmgSdh4ou=grR0FiwnM4dEojELmtHTmkyjtJEx5sw@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