Re: Monthly table partitioning for fast purges?

On Mon, 2003-08-04 at 09:02, Benjamin Jury wrote:
> You could create an index on the function date(), which strips the time
> information.

How much of a hit would there be if he had separate "monthly tables"
and UNIONed them?

> > -----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?

--
+-----------------------------------------------------------------+
| Ron Johnson, Jr.        Home: ron.l.johnson@cox.net             |
| Jefferson, LA  USA                                              |
|                                                                 |
| "I'm not a vegetarian because I love animals, I'm a vegetarian  |
|  because I hate vegetables!"                                    |
|    unknown                                                      |
+-----------------------------------------------------------------+