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

Поиск
Список
Период
Сортировка
От Marc G. Fournier
Тема Re: *very* slow query to summarize data for a month ...
Дата
Msg-id 20031111141328.X56037@ganymede.hub.org
обсуждение исходный текст
Ответ на Re: *very* slow query to summarize data for a month ...  (Greg Stark <gsstark@mit.edu>)
Ответы Re: *very* slow query to summarize data for a month ...  (Josh Berkus <josh@agliodbs.com>)
Re: *very* slow query to summarize data for a month ...  (Greg Stark <gsstark@mit.edu>)
Список pgsql-performance
Дерево обсуждения 
On Tue, 11 Nov 2003, Greg Stark wrote:

> Actually you might be able to get the same effect using function indexes
> like:
>
> create index i on traffic_log (month_trunc(runtime), company_id)

had actually thought of that one ... is it something that is only
available in v7.4?

ams=# create index i on traffic_logs ( month_trunc(runtime), company_id );
ERROR:  parser: parse error at or near "," at character 54

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

Предыдущее
От: Greg Stark
Дата:
Сообщение: Re: *very* slow query to summarize data for a month ...
Следующее
От: Christopher Browne
Дата:
Сообщение: Re: Suggestions for benchmarking 7.4RC2 against 7.3