multiple sessions to create index in parallel support

From: "James Pang (chaolpan)" <chaolpan(at)cisco(dot)com>
To: "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: multiple sessions to create index in parallel support
Date: 2022-06-21 10:18:20
Message-ID: PH0PR11MB5191540CA8085CAA8944A114D6B39@PH0PR11MB5191.namprd11.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2022-06-21 14:30:01 Re: multiple sessions to create index in parallel support
Previous Message Peter Geoghegan 2022-06-21 05:46:52 Re: parallel index creation: maintenance_work_mem not honored?