how to create index concurrently on paritioned table
От
李杰(慎追)
Тема
how to create index concurrently on paritioned table
Дата
Msg-id
db12e897-73ff-467e-94cb-4af03705435f.adger.lj@alibaba-inc.com
Список
Дерево обсуждения
how to create index concurrently on paritioned table "李杰(慎追)" <adger.lj@alibaba-inc.com>
Re: how to create index concurrently on paritioned table Justin Pryzby <pryzby@telsasoft.com>
Re: how to create index concurrently on paritioned table Justin Pryzby <pryzby@telsasoft.com>
Re: how to create index concurrently on partitioned table Justin Pryzby <pryzby@telsasoft.com>
Re: how to create index concurrently on partitioned table Michael Paquier <michael@paquier.xyz>
回复：how to create index concurrently on paritioned table "李杰(慎追)" <adger.lj@alibaba-inc.com>
Re: how to create index concurrently on partitioned table Justin Pryzby <pryzby@telsasoft.com>
回复：how to create index concurrently on partitioned table "李杰(慎追)" <adger.lj@alibaba-inc.com>
Re: 回复：how to create indexconcurrently on partitioned table Michael Paquier <michael@paquier.xyz>
回复：回复：how to create index concurrently on partitioned table "李杰(慎追)" <adger.lj@alibaba-inc.com>
Re: 回复：回复：how to createindex concurrently on partitioned table Michael Paquier <michael@paquier.xyz>
回复：回复：回复：how to create index concurrently on partitioned table "李杰(慎追)" <adger.lj@alibaba-inc.com>
回复：how to create index concurrently on paritioned table "李杰(慎追)" <adger.lj@alibaba-inc.com>
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
В списке pgsql-hackers по дате отправления
