Postgres Pro
Downloads
Home   >   mailing lists

multiple sessions to create index in parallel support - Mailing list pgsql-admin

From James Pang (chaolpan)
Subject multiple sessions to create index in parallel support
Date
Msg-id PH0PR11MB5191540CA8085CAA8944A114D6B39@PH0PR11MB5191.namprd11.prod.outlook.com
Whole thread Raw
Responses Re: multiple sessions to create index in parallel support  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Tree view

Hi,

   We have a large database that just migrated data from Oracle to Postgres(13.4), after data load. We try to create indexes ,  with only one connection , the create index automatically run in parallel (table size 40G) ,  then we started two connections and each session creating index on large table, but at this time, only 1 session parallel creating index, the other one creating index in serial. There are enough parallel_workers and memory.  Is that expected ?  only 1 session allowed to parallel index creating at the same time ?

 

Thanks,

 

James

pgsql-admin by date:

Previous
From: Peter Geoghegan
Date:
Subject: Re: parallel index creation: maintenance_work_mem not honored?
Next
From: Tom Lane
Date:
Subject: Re: multiple sessions to create index in parallel support