Re: [HACKERS] ALTER TABLE with Tablespace?

2004-06-19 Thread Gavin Sherry
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])


[HACKERS] ALTER TABLE with Tablespace?

2004-06-19 Thread Tatsuo Ishii
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.
--
Tatsuo Ishii

---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]