pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Tom Lane <tgl@sss.pgh.pa.us>
To: Rainer Mager <rainer@vanten.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: difficulties with time based queries
Date: Fri, 10 Apr 2009 01:20:45 -0400
Message-ID: <14161.1239340845@sss.pgh.pa.us> (raw)
In-Reply-To: <000001c9b99a$743da930$5cb8fb90$@com>
References: <003001c9b645$e8a7cec0$b9f76c40$@com>
	<e7f9235d0904051646j7e8374afncf79e3708ae40c20@mail.gmail.com>
	<003501c9b656$a9c73fe0$fd55bfa0$@com>
	<7371.1238981597@sss.pgh.pa.us>
	<000001c9b99a$743da930$5cb8fb90$@com>

"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

view thread (13+ messages)  latest in thread

Message-ID: <14161.1239340845@sss.pgh.pa.us>
Permalink:  ../14161.1239340845@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/14161.1239340845@sss.pgh.pa.us

copy link · copy postgr.es

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: tgl@sss.pgh.pa.us, rainer@vanten.com
  Subject: Re: difficulties with time based queries
  In-Reply-To: <14161.1239340845@sss.pgh.pa.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox