On Tue, 2010-07-27 at 20:38 +0000, Leif Gunnar Erlandsen wrote: > 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. Yes, it will have a performance impact. The table will be locked while it's being moved to the new tablespace, preventing both reads and writes until the operation is complete. Regards, Jeff Davis -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
