how to create index concurrently on paritioned table

From: 李杰(慎追) <adger(dot)lj(at)alibaba-inc(dot)com>
To: "pgsql-hackers" <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Cc: 曾文旌(义从) <wenjing(dot)zwj(at)alibaba-inc(dot)com>
Subject: how to create index concurrently on paritioned table
Date: 2020-06-03 12:22:29
Message-ID: db12e897-73ff-467e-94cb-4af03705435f.adger.lj@alibaba-inc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi hackers,

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?

Sincerely look forward to your reply.

Regards & Thanks Adger

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Paquier 2020-06-03 12:38:42 Re: Incorrect comment in be-secure-openssl.c
Previous Message Ants Aasma 2020-06-03 12:07:30 Re: what can go in root.crt ?