Re: Pull up aggregate subquery

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Hitoshi Harada <umi(dot)tanuki(at)gmail(dot)com>
Cc: Robert Haas <robertmhaas(at)gmail(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Pull up aggregate subquery
Date: 2011-05-25 15:03:10
Message-ID: 5744.1306335790@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hitoshi Harada <umi(dot)tanuki(at)gmail(dot)com> writes:
> 2011/5/25 Hitoshi Harada <umi(dot)tanuki(at)gmail(dot)com>:
>> So I'm still
>> thinking which of pulling up and parameterized scan is better.

> After more investigation I came up with third idea, pushing down
> RangeTblEntry to aggregate subquery. This sounds like a crazy idea,

Yes, it sure does. Won't that typically change the number of rows
produced by the subquery's jointree? And thus possibly change the
aggregate's result?

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2011-05-25 15:04:38 Re: Expression Evaluator used for creating the plan tree / stmt ?
Previous Message Alvaro Herrera 2011-05-25 14:58:41 Re: Expression Evaluator used for creating the plan tree / stmt ?