Re: Pull up aggregate subquery

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Pull up aggregate subquery
Дата
Msg-id 5744.1306335790@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Pull up aggregate subquery  (Hitoshi Harada <umi.tanuki@gmail.com>)
Ответы Re: Pull up aggregate subquery
Список pgsql-hackers
Hitoshi Harada <umi.tanuki@gmail.com> writes:
> 2011/5/25 Hitoshi Harada <umi.tanuki@gmail.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


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Expression Evaluator used for creating the plan tree / stmt ?
Следующее
От: Robert Haas
Дата:
Сообщение: Re: Reducing overhead of frequent table locks