ALTER TABLE with Tablespace?

From: Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp>
To: pgsql-hackers(at)postgresql(dot)org
Subject: ALTER TABLE with Tablespace?
Date: 2004-06-19 10:52:38
Message-ID: 20040619.195238.39154319.t-ishii@sra.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tatsuo Ishii 2004-06-19 11:08:15 pgpool 2.0RC1
Previous Message Andreas Pflug 2004-06-19 09:30:50 Re: Compilation failes in CVS tip