On Sat, 19 Jun 2004, Tatsuo Ishii wrote: > It seems ALTER TABLE does not support table space. I think this is > neccessary because: > > 1) if a data disk if full, users need to move table to another table > spaces. > > 2) if performance hits, users could move the table which is likely a > bottle neck to another table space. > > I know that pg_dump+pg_restore will do the trick, but I think > tablespace can handle this better.
I'm going to try and find some time to do this over the next few days. I figure it will mostly look like cluster() so shouldn't be too time consuming. I agree that it would be very useful, particularly for those upgrading to 7.5 and wanting to make use of tablespaces. Thanks, Gavin ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])