"Rainer Mager" <rai...@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 -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance