Re: Slow performance on MAX(primary_key)

Поиск
Список
Период
Сортировка
От Richard Huxton
Тема Re: Slow performance on MAX(primary_key)
Дата
Msg-id 200210170926.53170.dev@archonet.com
обсуждение исходный текст
Ответ на Re: Slow performance on MAX(primary_key)  (Keith Gray <keith@heart.com.au>)
Список pgsql-sql
On Thursday 17 Oct 2002 12:46 am, Keith Gray wrote:
> Getting MIN() adn MAX() seems fairly trivial to me.
>
> When is on an index or more importantly Primary
> Key it must be a common SQL.
>
> Would it be possible in the code to look at
> the field in MIN() or MAX() and if it is
> indexed use a similar method to the suggested
> SQL work around?
>
> Can I help this to happen?

Subscribe to pgsql-hackers and talk through a proposed hack there. The
developers always seem happy to receive contributions (you've just got to
look at the contrib folder for evidence).

--  Richard Huxton


В списке pgsql-sql по дате отправления:

Предыдущее
От: Ludwig Lim
Дата:
Сообщение: Re: getting the current date
Следующее
От: "Gaetano Mendola"
Дата:
Сообщение: Re: functions that return a dataset or set of rows