Re: multiple sessions to create index in parallel support

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: multiple sessions to create index in parallel support
Дата
Msg-id 2971652.1655823828@sss.pgh.pa.us
обсуждение исходный текст
Ответ на RE: multiple sessions to create index in parallel support  ("James Pang (chaolpan)" <chaolpan@cisco.com>)
Ответы RE: multiple sessions to create index in parallel support  ("James Pang (chaolpan)" <chaolpan@cisco.com>)
Список 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 по дате отправления:

Предыдущее
От: "James Pang (chaolpan)"
Дата:
Сообщение: RE: multiple sessions to create index in parallel support
Следующее
От: "James Pang (chaolpan)"
Дата:
Сообщение: RE: multiple sessions to create index in parallel support