Re: Parallel Plans and Cost of non-filter functions

From: "Tels" <nospam-pg-abuse(at)bloodgate(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Cc: pramsey(at)cleverelephant(dot)ca, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject: Re: Parallel Plans and Cost of non-filter functions
Date: 2017-11-04 13:27:25
Message-ID: 7aa5456373535ce270a7460a7742e0cf.squirrel@sm.webmail.pair.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Moin,

On Fri, November 3, 2017 7:13 pm, Tom Lane wrote:
> Paul Ramsey <pramsey(at)cleverelephant(dot)ca> writes:
>>> Whether I get a parallel aggregate seems entirely determined by the
>>> number
>>> of rows, not the cost of preparing those rows.
>
>> This is true, as far as I can tell and unfortunate. Feeding tables with
>> 100ks of rows, I get parallel plans, feeding 10ks of rows, never do, no
>> matter how costly the work going on within. That's true of changing
>> costs
>> on the subquery select list, and on the aggregate transfn.
>
> This sounds like it might be the same issue being discussed in
>
> https://www.postgresql.org/message-id/flat/CAMkU=1ycXNipvhWuweUVpKuyu6SpNjF=yHWu4c4US5JgVGxtZQ(at)mail(dot)gmail(dot)com

When looking at the web archive, the link is broken, even though in the
mail above it appears correct for me:

https://www.postgresql.org/message-id/28621.1509750807%40sss.pgh.pa.us

(shortened: http://bit.ly/2zetO5T)

Seems the email-obfuskation breaks such links?

Here is a short-link for people reading it via the archive on http:

http://bit.ly/2hF4lIt

Best regards,

Tels

Browse pgsql-hackers by date

  From Date Subject
Next Message Daniel Verite 2017-11-04 14:59:41 Re: Dynamic result sets from procedures
Previous Message Andres Freund 2017-11-04 13:15:00 Re: [HACKERS] pgsql: Fix freezing of a dead HOT-updated tuple