Re: Why does a simple query not use an obvious index?

Поиск
Список
Период
Сортировка
От Pierre-Frédéric Caillaud
Тема Re: Why does a simple query not use an obvious index?
Дата
Msg-id opsdj710chcq72hf@musicbox
обсуждение исходный текст
Ответ на Re: Why does a simple query not use an obvious index?  (Greg Stark <gsstark@mit.edu>)
Ответы Re: Why does a simple query not use an obvious index?  (Bruno Wolff III <bruno@wolff.to>)
Список pgsql-performance
Дерево обсуждения 
>> Also, count(*) is likely to always generate a seq scan due to the way
>> aggregates are implemented currently in pgsql.  you might want to try:


    By the way, in an ideal world, count(*) should only read the index on the
timetamp column, not the rows. I guess this is not the case. Would this be
an useful optimization ?

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

Предыдущее
От: Pierre-Frédéric Caillaud
Дата:
Сообщение: Re: Why does a simple query not use an obvious index?
Следующее
От: Pierre-Frédéric Caillaud
Дата:
Сообщение: Re: Why does a simple query not use an obvious index?