Re: Index not being used in MAX function (7.2.3) - Mailing list pgsql-general

From Tom Lane
Subject Re: Index not being used in MAX function (7.2.3)
Date
Msg-id 20004.1055350977@sss.pgh.pa.us
Whole thread Raw
In response to Re: Index not being used in MAX function (7.2.3)  ("Jim C. Nasby" <jim@nasby.net>)
Responses Re: Index not being used in MAX function (7.2.3)  (Ang Chin Han <angch@bytecraft.com.my>)
Re: Index not being used in MAX function (7.2.3)  ("Jim C. Nasby" <jim@nasby.net>)
List pgsql-general
"Jim C. Nasby" <jim@nasby.net> writes:
> Not to drag this out further, but you might want to hold off on that
> patch. 7.4 is supposed to use indexes for max/min.

Where did you get that idea?

There's been no change in the basic problem, which is that no one has
proposed a reasonably general method of translating aggregates into
index manipulations.  Postgres has an extremely general, extensible
concept of aggregates, and we're not going to mess it up with some
poorly-designed hack.  But show me a clean design and implementation,
and it'll go in.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Performance of query (fwd)
Next
From: "Dann Corbit"
Date:
Subject: Re: Index not being used in MAX function (7.2.3)