Re: max_parallel_degree > 0 for 9.6 beta - Mailing list pgsql-hackers

From Tom Lane
Subject Re: max_parallel_degree > 0 for 9.6 beta
Date
Msg-id 27991.1461280810@sss.pgh.pa.us
Whole thread Raw
In response to Re: max_parallel_degree > 0 for 9.6 beta  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: max_parallel_degree > 0 for 9.6 beta  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
Robert Haas <robertmhaas@gmail.com> writes:
> On Thu, Apr 21, 2016 at 4:01 PM, Gavin Flower
> <GavinFlower@archidevsys.co.nz> wrote:
>> Why not 4?  As most processors now have at least 4 physical cores, & surely
>> it be more likely to flush out race conditions.

> Because if we did that, then it's extremely likely that people would
> end up writing queries that are faster only if workers are present,
> and then not get any workers.

Is that because max_worker_processes is only 8 by default?  Maybe we
need to raise that, at least for beta purposes?
        regards, tom lane



pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: max_parallel_degree > 0 for 9.6 beta
Next
From: Tom Lane
Date:
Subject: Re: [COMMITTERS] pgsql: Add trigonometric functions that work in degrees.