Re: difficulties with time based queries

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: difficulties with time based queries
Дата
Msg-id 14161.1239340845@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: difficulties with time based queries  ("Rainer Mager" <rainer@vanten.com>)
Список pgsql-performance
"Rainer Mager" <rainer@vanten.com> writes:
> So, I need indices that make it fast querying against start_time as well as
> all possible combinations of channel, player, and ad.

There's some general principles in the manual --- have you read
http://www.postgresql.org/docs/8.3/static/indexes.html
especially 11.3 and 11.5?

            regards, tom lane

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

Предыдущее
От: "Rainer Mager"
Дата:
Сообщение: Re: difficulties with time based queries
Следующее
От: Josh Berkus
Дата:
Сообщение: Re: Using IOZone to simulate DB access patterns