Re: how to create index concurrently on paritioned table

2020-06-07 Thread Justin Pryzby
On Sat, Jun 06, 2020 at 09:23:32AM -0500, Justin Pryzby wrote: > 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

Re: how to create index concurrently on paritioned table

2020-06-06 Thread Justin Pryzby
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 a