Re: Index not being used in MAX function (7.2.3)

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Index not being used in MAX function (7.2.3)
Дата
Msg-id 20004.1055350977@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Index not being used in MAX function (7.2.3)  ("Jim C. Nasby" <jim@nasby.net>)
Ответы 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>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Performance of query (fwd)
Следующее
От: "Dann Corbit"
Дата:
Сообщение: Re: Index not being used in MAX function (7.2.3)