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:
Best regards,
Tels
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 |