Re: Monthly table partitioning for fast purges? - Mailing list pgsql-general

From Jean-Luc Lachance
Subject Re: Monthly table partitioning for fast purges?
Date
Msg-id 3F2FCD1B.C01DD910@nsd.ca
Whole thread Raw
In response to Re: Monthly table partitioning for fast purges?  ("Shridhar Daithankar" <shridhar_daithankar@persistent.co.in>)
Responses Re: Monthly table partitioning for fast purges?  (Ron Johnson <ron.l.johnson@cox.net>)
List 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

pgsql-general by date:

Previous
From: "scott.marlowe"
Date:
Subject: Re: like performance w/o wildcards.
Next
From: Tom Lane
Date:
Subject: Re: like performance w/o wildcards.