Re: increased max_parallel_workers_per_gather results in fewerworkers?

Поиск
Список
Период
Сортировка
От Luis Carril
Тема Re: increased max_parallel_workers_per_gather results in fewerworkers?
Дата
Msg-id LEXPR01MB1182C770FBB48C33231CD2CAE7890@LEXPR01MB1182.DEUPRD01.PROD.OUTLOOK.DE
обсуждение исходный текст
Ответ на Re: increased max_parallel_workers_per_gather results in fewerworkers?  (Sebastian Dressler <sebastian@swarm64.com>)
Список pgsql-performance
Дерево обсуждения
Hi,
   on top of the settings that Sebastian suggested, you can also try disabling the participation of the leader (i.e. the main backend process for your connection) in the distribution of the parallel workload:

SET parallel_leader_participation TO false

  Depending on your workload the leader could be saturated if it has to do a share of the workload and aggregate the results of all the workers.

Cheers
Luis

В списке pgsql-performance по дате отправления:

Предыдущее
От: Sebastian Dressler
Дата:
Сообщение: Re: increased max_parallel_workers_per_gather results in fewerworkers?
Следующее
От: Tomas Vondra
Дата:
Сообщение: Re: increased max_parallel_workers_per_gather results in fewerworkers?