You could create an index on the function date(), which strips the time
information.
> -----Original Message-----
> From: psql-mail@freeuk.com [mailto:psql-mail@freeuk.com]
> 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?