You could create an index on the function date(), which strips the time information.
> -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: 04 August 2003 14:01 > To: PgSQL General ML > Subject: Re: [GENERAL] Monthly table partitioning for fast purges? > > > I am looking at ways to speed up queries, the most common way by for > queries to be constrianed is by date range. I have indexed the date > column. Queries are still slower than i would like. ... > The date column is of type timestamp (and so goes right down > to seconds) > , most user queries are only concerned about whole days without the > times, (but hte time data is required for other queries) can i do > something with an index of the timestamps cast to dates? and > then cast > the queries to dates too? ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly