alter table set tablespace

From: "Leif Gunnar Erlandsen" <leif(at)lako(dot)no>
To: pgsql-general(at)postgresql(dot)org
Subject: alter table set tablespace
Date: 2010-07-27 20:38:00
Message-ID: 201007272038.o6RKc1Bi000857@ogoleif.lako.no
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I want to move one table from one disk to another.

In order to do this I wanted to create a new tablespace on the new disks and
issue the command alter table tablename set tablespace tablespacename;

The question is, will this in any way affect the database which is in heavily
use?

The table in question is the largest one approximately 90GB.

Thanks

Leif Gunnar Erlandsen

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alban Hertroys 2010-07-27 20:38:08 Re: Increase Query Speed
Previous Message Jamie Kahgee 2010-07-27 19:48:18 Re: Increase Query Speed