Re: What needs to be done for real Partitioning?

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>
To: Greg Stark <gsstark@mit.edu>
Cc: Josh Berkus <josh@agliodbs.com>, pgsql-performance@postgresql.org
Date: 2005-03-20T23:05:25Z
Lists: pgsql-performance
Greg Stark <gsstark@mit.edu> writes:
> You could argue for some sort of setup where you could take a partition
> "offline" during which you could safely do things like export or manipulate
> the data. But that's awfully limiting. What if I want to do things like add
> columns, or change data types, or any other manipulation that breaks the
> symmetry with the production partitioned table.

[ scrapes eyebrows off ceiling... ]  You don't really expect to be able
to do that kind of thing to just one partition do you?

			regards, tom lane