Re: Parallel Plans and Cost of non-filter functions

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Paul Ramsey <pramsey(at)cleverelephant(dot)ca>
Cc: Pgsql Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Parallel Plans and Cost of non-filter functions
Date: 2017-11-03 23:13:27
Message-ID: 28621.1509750807@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Claudio Freire 2017-11-03 23:14:26 Re: Small improvement to compactify_tuples
Previous Message Paul Ramsey 2017-11-03 22:56:24 Re: Parallel Plans and Cost of non-filter functions