alter table set tablespace

Поиск
Список
Период
Сортировка
Искать
От
Leif Gunnar Erlandsen
Тема
alter table set tablespace
Дата
Msg-id
201007272038.o6RKc1Bi000857@ogoleif.lako.no
Список
Дерево обсуждения
alter table set tablespace "Leif Gunnar Erlandsen" <leif@lako.no>
Re: alter table set tablespace Jeff Davis <pgsql@j-davis.com>
Re: alter table set tablespace ChronicDB Community Team <community@chronicdb.com>
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 по дате отправления
От: Alban Hertroys
Дата:
Сообщение: Re: Increase Query Speed
От: Jeff Davis
Дата:
Сообщение: Re: alter table set tablespace
FAQ