Re: Choosing parallel_degree - Mailing list pgsql-hackers

From Julien Rouhaud
Subject Re: Choosing parallel_degree
Date
Msg-id [email protected]
Whole thread Raw
In response to Re: Choosing parallel_degree  (James Sewell <[email protected]>)
Responses Re: Choosing parallel_degree
List pgsql-hackers
On 21/03/2016 05:18, James Sewell wrote:
> OK cool, thanks.
>
> Can we remove the minimum size limit when the per table degree setting
> is applied?
>
> This would help for tables with 2  - 1000 pages combined with a high CPU
> cost aggregate.
>

Attached v4 implements that. It also makes sure that the chosen
parallel_degree won't be more than the relation's estimated number of pages.

--
Julien Rouhaud
http://dalibo.com - http://dalibo.org

Attachment

pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: pgbench - allow backslash-continuations in custom scripts
Next
From: Kevin Grittner
Date:
Subject: Re: [PATCH] we have added support for box type in SP-GiST index