Re: Wrong plan for subSELECT with GROUP BY - Mailing list pgsql-performance

From Tom Lane
Subject Re: Wrong plan for subSELECT with GROUP BY
Date
Msg-id 23992.1147442716@sss.pgh.pa.us
Whole thread Raw
In response to Wrong plan for subSELECT with GROUP BY  (Antal Attila <atesz@ritek.hu>)
Responses Re: Wrong plan for subSELECT with GROUP BY
List 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 by date:

Previous
From: Antal Attila
Date:
Subject: Wrong plan for subSELECT with GROUP BY
Next
From: "andremachado"
Date:
Subject: Firebird 1.5.3 X Postgresql 8.1.3 (linux and windows)