Re: max_parallel_workers can't actually be set?

Поиск
Список
Период
Сортировка
От Sergei Kornilov
Тема Re: max_parallel_workers can't actually be set?
Дата
Msg-id 4956851566065287@sas2-1cb6b6547741.qloud-c.yandex.net
обсуждение исходный текст
Ответ на max_parallel_workers can't actually be set?  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: max_parallel_workers can't actually be set?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Hello

> Try this:
> alter system set max_parallel_workers = 20;
> and restart the system.
> max_parallel_workers is still 8

Hmm, I got 20 on my local 11.5 and on HEAD.

> which should certainly not happen for a PGC_POSTMASTER parameter.

But max_parallel_workers is PGC_USERSET and this behavior seems be documented:

> Also, note that a setting for this value which is higher than max_worker_processes will have no effect, since
parallelworkers are taken from the pool of worker processes established by that setting.
 

regards, Sergei



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

Предыдущее
От: Darafei "Komяpa" Praliaskouski
Дата:
Сообщение: Re: max_parallel_workers can't actually be set?
Следующее
От: Ibrar Ahmed
Дата:
Сообщение: Re: max_parallel_workers can't actually be set?