Re: Wrong plan for subSELECT with GROUP BY

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Wrong plan for subSELECT with GROUP BY
Дата
Msg-id 23992.1147442716@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Wrong plan for subSELECT with GROUP BY  (Antal Attila <atesz@ritek.hu>)
Ответы Re: Wrong plan for subSELECT with GROUP BY
Список pgsql-performance
Antal Attila <atesz@ritek.hu> writes:
> If this is a deficiency of the planner, I'd like to suggest this feature
> into the planner.

This really falls into the category of "you've got to be kidding".
There's no way that it'd be reasonable for the planner to expend cycles
on every query to look for corner cases like this.  Do the
hand-optimization instead.

            regards, tom lane

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

Предыдущее
От: Antal Attila
Дата:
Сообщение: Wrong plan for subSELECT with GROUP BY
Следующее
От: "andremachado"
Дата:
Сообщение: Firebird 1.5.3 X Postgresql 8.1.3 (linux and windows)