From: Tom Lane <tgl@sss.pgh.pa.us>
To: "James Pang (chaolpan)" <chaolpan@cisco.com>
cc: "pgsql-admin@lists.postgresql.org" <pgsql-admin@lists.postgresql.org>
Subject: Re: multiple sessions to create index in parallel support
In-reply-to: 
 <PH0PR11MB5191BB64F516447A79FD4AA6D6B39@PH0PR11MB5191.namprd11.prod.outlook.com>
References: 
 <PH0PR11MB5191540CA8085CAA8944A114D6B39@PH0PR11MB5191.namprd11.prod.outlook.com>
 <2944693.1655821801@sss.pgh.pa.us>
 <PH0PR11MB5191BB64F516447A79FD4AA6D6B39@PH0PR11MB5191.namprd11.prod.outlook.com>
Comments: In-reply-to "James Pang (chaolpan)" <chaolpan@cisco.com>
	message dated "Tue, 21 Jun 2022 14:44:23 -0000"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <2971651.1655823828.1@sss.pgh.pa.us>
Content-Transfer-Encoding: quoted-printable
Date: Tue, 21 Jun 2022 11:03:48 -0400
Message-ID: <2971652.1655823828@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/2971652.1655823828%40sss.pgh.pa.us>
Precedence: bulk

"James Pang (chaolpan)" <chaolpan@cisco.com> writes:
> Max_parallel_workers and max_parallel_maintenance_workers both equal to =
32,    one session create one index in a large table show parallel 8 worke=
rs,   the other session creating one index in another separate table alway=
s in serial. Even increase max_parallel_worers and max_parallel_maintenanc=
e_workers to 64, still show one is parallel 8 workers, the other is done i=
n serial.

Hmm, what about max_worker_processes ?  That's an independent limit.

			regards, tom lane