Time to move table to new tablespace

Поиск
Список
Период
Сортировка
От Jason Buberel
Тема Time to move table to new tablespace
Дата
Msg-id CAAPEApExVTTUKQcN262FNtWXLOQzKuyY4gtpgo_NLkLtHaUSug@mail.gmail.com
обсуждение исходный текст
Ответы Re: Time to move table to new tablespace  (Craig Ringer <ringerc@ringerc.id.au>)
Re: Time to move table to new tablespace  (Ondrej Ivanič <ondrej.ivanic@gmail.com>)
Список pgsql-general
Дерево обсуждения
I'm considering the migration of an existing large (2.3TB) table to a new tablespace. The table size, according to the '\dt+' command:

 public | city_summary | table | altosresearch | 2345 GB    | 

Are there any considerations - besides the usual disk and network IO constraints - that I need to take into account when estimating the amount of time that would be required for the following commands to complete?

psql> create tablespace 'newstorage' location '/some/new/path';
psql> alter table city_summary set tablespace = 'newstorage';

Any other recommendations are welcome, such as "You are an idiot for not using partitioning in the first place" :)

--
Jason L. Buberel
CTO, Altos Research
http://www.altosresearch.com/
650.603.0907

В списке pgsql-general по дате отправления:

Предыдущее
От: Dmitriy Igrishin
Дата:
Сообщение: Re: How to code lo_creat & lo_write & lo_read in non-blocking mode
Следующее
От: Phoenix Kiula
Дата:
Сообщение: Re: URGENT: temporary table not recognized?