From: Justin Pryzby <pryzby@telsasoft.com>
To: 李杰(慎追) <adger.lj@alibaba-inc.com>
Cc: pgsql-hackers <pgsql-hackers@lists.postgresql.org>
Cc: 曾文旌(义从) <wenjing.zwj@alibaba-inc.com>
Subject: Re: how to create index concurrently on paritioned table
Date: Sat, 6 Jun 2020 09:23:32 -0500
Message-ID: <20200606142332.GH22473@telsasoft.com> (raw)
In-Reply-To: <db12e897-73ff-467e-94cb-4af03705435f.adger.lj@alibaba-inc.com>
References: <db12e897-73ff-467e-94cb-4af03705435f.adger.lj@alibaba-inc.com>
On Wed, Jun 03, 2020 at 08:22:29PM +0800, 李杰(慎追) wrote:
> Partitioning is necessary for very large tables.
> However, I found that postgresql does not support create index concurrently on partitioned tables.
> The document show that we need to create an index on each partition individually and then finally create the partitioned index non-concurrently.
> This is undoubtedly a complex operation for DBA, especially when there are many partitions.
> Therefore, I wonder why pg does not support concurrent index creation on partitioned tables?
> What are the difficulties of this function?
> If I want to implement it, what should I pay attention?
Maybe I'm wrong, but I don't think there's any known difficulty - just that
nobody did it yet. You should pay attention to what happens on error, but
hopefully you wouldn't need to add much code and can rely on existing code to
paths to handle that right.
I think you'd look at the commits and code implementing indexes on partitioned
tables and CREATE INDEX CONCURRENTLY. And maybe any following commits with
fixes.
You'd first loop around all children (recursively if there are partitions which
are themselves partitioned) and create indexes concurrently.
--
Justin
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: pgsql-hackers@postgresql.org
Cc: pryzby@telsasoft.com, adger.lj@alibaba-inc.com, pgsql-hackers@lists.postgresql.org, wenjing.zwj@alibaba-inc.com
Subject: Re: how to create index concurrently on paritioned table
In-Reply-To: <20200606142332.GH22473@telsasoft.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox