Re: Wrong plan for subSELECT with GROUP BY

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Antal Attila <atesz(at)ritek(dot)hu>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Wrong plan for subSELECT with GROUP BY
Date: 2006-05-12 14:05:16
Message-ID: 23992.1147442716@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Antal Attila <atesz(at)ritek(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message andremachado 2006-05-12 14:48:52 Firebird 1.5.3 X Postgresql 8.1.3 (linux and windows)
Previous Message Antal Attila 2006-05-12 12:43:16 Wrong plan for subSELECT with GROUP BY