On Wed, May 11, 2016 at 1:48 PM, David G. Johnston
<david.g.johnston@gmail.com> wrote:
> What happens when there are no workers available due to max_worker_processes
> already being assigned?
Then the leader runs the plan after all.
> Related question, if max_parallel_degree is >1 and "the requested number of
> workers may not actually be available at runtime" is true, does the degree
> of parallelism minimize at 1 worker + leader or will the leader simply run
> the query by itself?
If the leader can get no workers at all, it will simply run the query
by itself. Of course, it tries to get as many as it can.
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company