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

From Tom Lane
Subject Re: multiple sessions to create index in parallel support
Date
Msg-id 2971652.1655823828@sss.pgh.pa.us
Whole thread Raw
In response to RE: multiple sessions to create index in parallel support  ("James Pang (chaolpan)" <chaolpan@cisco.com>)
Responses RE: multiple sessions to create index in parallel support  ("James Pang (chaolpan)" <chaolpan@cisco.com>)
List pgsql-admin
"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
largetable show parallel 8 workers,   the other session creating one index in another separate table always in serial.
Evenincrease max_parallel_worers and max_parallel_maintenance_workers to 64, still show one is parallel 8 workers, the
otheris done in serial. 

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

            regards, tom lane



pgsql-admin by date:

Previous
From: "James Pang (chaolpan)"
Date:
Subject: RE: multiple sessions to create index in parallel support
Next
From: "James Pang (chaolpan)"
Date:
Subject: RE: multiple sessions to create index in parallel support