Re: Bad query optimisation - Mailing list pgsql-hackers

From Bruno Wolff III
Subject Re: Bad query optimisation
Date
Msg-id 20021130235058.GA19268@wolff.to
Whole thread Raw
In response to Re: Bad query optimisation  (Greg Stark <gsstark@mit.edu>)
List pgsql-hackers
On Sat, Nov 30, 2002 at 18:23:56 -0500, Greg Stark <gsstark@mit.edu> wrote:
> 
> It seems like this should be an important optimization given the number of
> applications that request max(foo) in a broken attempt to implement sequences.
> Occasionally it's not even a broken attempt too.

This has been discussed on the mailing lists many times. You can rewrite
the queries using order by and limit clauses if the column is appropiately
indexed.


pgsql-hackers by date:

Previous
From: ow
Date:
Subject: Re: 7.4 Wishlist
Next
From: "Christopher Kings-Lynne"
Date:
Subject: tsearch thoughts