Re: difficulties with time based queries - Mailing list pgsql-performance

From Tom Lane
Subject Re: difficulties with time based queries
Date
Msg-id 14161.1239340845@sss.pgh.pa.us
Whole thread Raw
In response to Re: difficulties with time based queries  ("Rainer Mager" <rainer@vanten.com>)
List 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 by date:

Previous
From: "Rainer Mager"
Date:
Subject: Re: difficulties with time based queries
Next
From: Josh Berkus
Date:
Subject: Re: Using IOZone to simulate DB access patterns