Re: Migrating tables to new tablespace, freed up space doesn't match moved data

Поиск
Список
Период
Сортировка
От Prashanth Ranjalkar
Тема Re: Migrating tables to new tablespace, freed up space doesn't match moved data
Дата
Msg-id CAMBytER7K6a+NZ0-w3ZmeoV+dRn-p+pie9vwCLsOR1-Jj_jOFQ@mail.gmail.com
обсуждение исходный текст
Ответ на Migrating tables to new tablespace, freed up space doesn't match moved data  (Brian Fehrle <brianf@consistentstate.com>)
Список pgsql-admin
Дерево обсуждения
When any files that are in large size moved out or deleted, the reclaiming of the space at  certain operating system level may not be fast enough as soon as the operation is completed and may take time.. Another possibility would be that stats are not updated, worth to analyze the tables that are moved into tablespace.

 
Thanks & Regards,
 
Prashanth Ranjalkar
Database Consultant & Architect


On Thu, Feb 21, 2013 at 2:45 AM, Brian Fehrle <brianf@consistentstate.com> wrote:
Hi all,

I've set up a tablespace on a different partition from the main data directory. I moved a few tables and indexes over to the new tablespace and the disk space used in this new tablespace doesn't match the amount of data 'freed up' from the main data directory. The tablespace is sitting at 15 GB used, but the space freed up on the main partition is about 10 GB.

Any thoughts as to why I didn't see as much space freed up as I thought I would?

Thanks,
- Brian F


--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

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

Предыдущее
От: Prashanth Ranjalkar
Дата:
Сообщение: Re: Pg 9.1 master-slave replication
Следующее
От: Ned Wolpert
Дата:
Сообщение: Database corruption event, unlockable rows, possibly bogus virtual xids? (-1/4444444444)