| From: | Julien Rouhaud <julien(dot)rouhaud(at)dalibo(dot)com> |
|---|---|
| To: | James Sewell <james(dot)sewell(at)lisasoft(dot)com>, David Rowley <david(dot)rowley(at)2ndquadrant(dot)com> |
| Cc: | Robert Haas <robertmhaas(at)gmail(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, Paul Ramsey <pramsey(at)cleverelephant(dot)ca> |
| Subject: | Re: Choosing parallel_degree |
| Date: | 2016-03-21 19:38:40 |
| Message-ID: | 56F04DC0.9060308@dalibo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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 | Content-Type | Size |
|---|---|---|
| rel_parallel_degree_v4.diff | text/plain | 6.8 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kevin Grittner | 2016-03-21 19:38:49 | Re: [PATCH] we have added support for box type in SP-GiST index |
| Previous Message | Robert Haas | 2016-03-21 19:33:53 | Re: pgbench - allow backslash-continuations in custom scripts |