Re: max_parallel_workers can't actually be set? - Mailing list pgsql-hackers

From Sergei Kornilov
Subject Re: max_parallel_workers can't actually be set?
Date
Msg-id 4956851566065287@sas2-1cb6b6547741.qloud-c.yandex.net
Whole thread Raw
In response to max_parallel_workers can't actually be set?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: max_parallel_workers can't actually be set?  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: Darafei "Komяpa" Praliaskouski
Date:
Subject: Re: max_parallel_workers can't actually be set?
Next
From: Ibrar Ahmed
Date:
Subject: Re: max_parallel_workers can't actually be set?