Re: Bad query optimisation

Поиск
Список
Период
Сортировка
От Bruno Wolff III
Тема Re: Bad query optimisation
Дата
Msg-id 20021130235058.GA19268@wolff.to
обсуждение исходный текст
Ответ на Re: Bad query optimisation  (Greg Stark <gsstark@mit.edu>)
Список 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 по дате отправления:

Предыдущее
От: ow
Дата:
Сообщение: Re: 7.4 Wishlist
Следующее
От: "Christopher Kings-Lynne"
Дата:
Сообщение: tsearch thoughts