Re: Tablespaces

Josh Berkus wrote:
> #3: ALTER TABLE .... CHANGE TABLESPACE:
> This is strictly in the class of "would be a very nice & useful feature if
> it's not too difficult". ?
>
> Given how painful it is to drop & replace a table with multiple dependencies
> (on some databases, only possible by droping & re-loading the entire
> database) it would be nice to have an ALTER TABLE command that moved the
> table to another tablespace. ? ?It doesn't *seem* to me that this would be a
> very challenging bit of programming, as the operation would be very similar
> to REINDEX in the manipulation of files. ? (But what I know, really?)
>
> Once tablespaces are a feature and some users start using them for quota
> management, there will quickly develop situations where the original
> tablespace for a db runs out of room and can't be resized. ? Being able to
> move the table "in situ" then becomes vital, especially on very large
> databases ... and when someday combined with partitioned tables, will become
> essential.
>
> Further, we will get an *immediate* flurry of requests from users who just
> upgraded to 7.5 and want to make use of the tablespaces feature on an
> existing production database.

If we don't implement moving tables between tablespaces, we should add a
stub for it in the grammer and mention it is not implemented yet,
because if we don't, we will get tons of questions.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073