From: | Simon Riggs <simon(at)2ndQuadrant(dot)com> |
---|---|
To: | Paul Ramsey <pramsey(at)cleverelephant(dot)ca> |
Cc: | Robert Haas <robertmhaas(at)gmail(dot)com>, Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>, Julien Rouhaud <julien(dot)rouhaud(at)dalibo(dot)com>, James Sewell <james(dot)sewell(at)lisasoft(dot)com>, David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, Andreas Ulbrich <andreas(dot)ulbrich(at)matheversum(dot)de> |
Subject: | Re: Choosing parallel_degree |
Date: | 2016-04-08 16:06:46 |
Message-ID: | CANP8+jJsZt-iZ4_v6c7mQM2bL3PuoO7aLKo+rgPHR45=Yn19EQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On 8 April 2016 at 17:00, Paul Ramsey <pramsey(at)cleverelephant(dot)ca> wrote:
> On Fri, Apr 8, 2016 at 8:23 AM, Robert Haas <robertmhaas(at)gmail(dot)com> wrote:
> > On Fri, Apr 8, 2016 at 1:22 AM, Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>
> wrote:
> >> Other than that, patch looks good and I have marked it as Ready For
> >> Committer. Hope, we get this for 9.6.
> >
> > Committed. I think this is likely to make parallel query
> > significantly more usable in 9.6.
>
> I'm kind of worried that it will make it yet less usable for PostGIS,
> since approaches that ignore costs in favour of relpages will
> dramatically under-resource our queries. I can spin a query for
> multiple seconds on a table with less than 100K records, not even
> trying very hard.
>
Doesn't sound good.
> Functions have very unequal CPU costs, and we're talking here about
> using CPUs more effectively, why are costs being given the see-no-evil
> treatment? This is as true in core as it is in PostGIS, even if our
> case is a couple orders of magnitude more extreme: a filter based on a
> complex combination of regex queries will use an order of magnitude
> more CPU than one that does a little math, why plan and execute them
> like they are the same?
>
Functions have user assignable costs.
> As it stands now, it seems like out of the box PostGIS users will
> actually not see much benefit from parallelism unless they manhandle
> their configuration settings to force it.
>
Does this concern apply to this patch, or to the general situation for 9.6.
Please suggest what you would like to see.
--
Simon Riggs http://www.2ndQuadrant.com/
<http://www.2ndquadrant.com/>
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
From | Date | Subject | |
---|---|---|---|
Next Message | David Steele | 2016-04-08 16:08:16 | Re: Batch update of indexes |
Previous Message | Paul Ramsey | 2016-04-08 16:00:53 | Re: Choosing parallel_degree |