Re: *very* slow query to summarize data for a month ...

Поиск
Список
Период
Сортировка
От Neil Conway
Тема Re: *very* slow query to summarize data for a month ...
Дата
Msg-id 87u15bx2g1.fsf@mailbox.samurai.com
обсуждение исходный текст
Ответ на Re: *very* slow query to summarize data for a month ...  ("Patrick Hatcher" <PHatcher@macys.com>)
Список pgsql-performance
"Patrick Hatcher" <PHatcher@macys.com> writes:
> Do you have an index on ts.bytes?  Josh had suggested this and after I put
> it on my summed fields, I saw a speed increase.

What's the reasoning behind this? ISTM that sum() should never use an
index, nor would it benefit from using one.

-Neil


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

Предыдущее
От: Josh Berkus
Дата:
Сообщение: Re: *very* slow query to summarize data for a month ...
Следующее
От: Neil Conway
Дата:
Сообщение: Re: *very* slow query to summarize data for a month ...