Re: Monthly table partitioning for fast purges?

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(dot)l(dot)johnson(at)cox(dot)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(at)postgresql(dot)org