Re: index performance question

Поиск
Список
Период
Сортировка
От Bruno Wolff III
Тема Re: index performance question
Дата
Msg-id 20020918202144.GA4371@wolff.to
обсуждение исходный текст
Ответ на index performance question  (Laurette Cisneros <laurette@nextbus.com>)
Ответы Re: index performance question  (Laurette Cisneros <laurette@nextbus.com>)
Список pgsql-admin
On Wed, Sep 18, 2002 at 13:09:07 -0700,
  Laurette Cisneros <laurette@nextbus.com> wrote:
>
> Aren't aggregates smart enough to use an index on the column?  This takes 8
> minutes to run!  I can't see that I should have to build a functional index
> (is it possible for an aggregate?) to get this to run faster?

I don't believe a functional index would work for an aggregate.

The way to do this is to use an order by clause and a limit 1 clause.

This has been discussed a lot on the lists and you should be able to find
more details in the archives.

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

Предыдущее
От: Laurette Cisneros
Дата:
Сообщение: index performance question
Следующее
От: Laurette Cisneros
Дата:
Сообщение: Re: index performance question