alter table set tablespace - Mailing list pgsql-general

From Leif Gunnar Erlandsen
Subject alter table set tablespace
Date
Msg-id 201007272038.o6RKc1Bi000857@ogoleif.lako.no
Whole thread Raw
Responses Re: alter table set tablespace  (Jeff Davis <pgsql@j-davis.com>)
List 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


pgsql-general by date:

Previous
From: Alban Hertroys
Date:
Subject: Re: Increase Query Speed
Next
From: Jeff Davis
Date:
Subject: Re: alter table set tablespace