Horton

Re: Monthly table partitioning for fast purges?

Jean-Luc Lachance <jllachan@nsd.ca>

View thread View on postgr.es
From: Jean-Luc Lachance <jllachan@nsd.ca>
To: Ron Johnson <ron.l.johnson@cox.net>
Cc: PgSQL General ML <pgsql-general@postgresql.org>
Date: 2003-08-05T15:28:27Z
Lists: pgsql-general 
I second that.
I have discussed adding partitioning tables almost a year ago...
No need to partition a functional index or anything like that.
Just partition on a specific field.


Ron Johnson wrote:
>[...]
> Partitioning "should" be put on the TODO list soon after tablespaces
> (or DBA-defined directories) is implemented.
> 
> --
> +-----------------------------------------------------------------+
> | 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                                                      |
> +-----------------------------------------------------------------+
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org