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