Re: smart or dumb partition? - Mailing list pgsql-general

From Greg Stark
Subject Re: smart or dumb partition?
Date
Msg-id 407d949e0908071644h7b33998flf9bab9b631c431ad@mail.gmail.com
Whole thread Raw
In response to smart or dumb partition?  (Bob Gobeille <bob.gobeille@hp.com>)
Responses Re: smart or dumb partition?
List pgsql-general
On Sat, Aug 8, 2009 at 12:27 AM, Bob Gobeille<bob.gobeille@hp.com> wrote:
> I gather from rtfm that it is typical to set up partitions so that the
> "master" table has no records.  But from my understanding of partitions and
> doing some tests, I don't see any reason that has to be.  So I'm wondering
> if I'm missing some subtle (or not so subtle) point about partitions?

It's purely a convenience issue. Any child partition can be removed
later, The parent will be a pain if you ever want to remove it from
the partitioning structure.

--
greg
http://mit.edu/~gsstark/resume.pdf

pgsql-general by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: psql and Emacs on Windows
Next
From: "Joshua D. Drake"
Date:
Subject: 2nd call for papers (PostgreSQL West)