Re: Parallel Aggregate - Mailing list pgsql-hackers

From Robert Haas
Subject Re: Parallel Aggregate
Date
Msg-id CA+TgmoY2CiFhJYt-p9xbfYvQZBAf3tb=zvNHTKotqG+4QAn+Nw@mail.gmail.com
Whole thread Raw
In response to Re: Parallel Aggregate  (James Sewell <james.sewell@lisasoft.com>)
Responses Re: Parallel Aggregate
List pgsql-hackers
On Mon, Mar 14, 2016 at 6:24 PM, James Sewell <james.sewell@lisasoft.com> wrote:
> Any chance of getting a GUC (say min_parallel_degree) added to allow setting
> the initial value of parallel_degree, then changing the small relation check
> to also pass if parallel_degree > 1?
>
> That way you could set min_parallel_degree on a query by query basis if you
> are running aggregates which you know will take a lot of CPU.
>
> I suppose it wouldn't make much sense at all to set globally though, so it
> could just confuse matters.

I kind of doubt this would work well, but somebody could write a patch
for it and try it out.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company



pgsql-hackers by date:

Previous
From: James Sewell
Date:
Subject: Re: Parallel Aggregate
Next
From: Tomas Vondra
Date:
Subject: Re: Parallel Aggregate