Re: space not reclaimed after repeated full vacuums

Поиск
Список
Период
Сортировка
От Tom O'Brien
Тема Re: space not reclaimed after repeated full vacuums
Дата
Msg-id 7A3E1242FA9989439AD1F9B2D71C287F0B6B6C82@sottmxs05.entrust.com
обсуждение исходный текст
Ответ на space not reclaimed after repeated full vacuums  (Tom O'Brien <Tom.OBrien@entrust.com>)
Список pgsql-admin

> I left this running over the weekend, and was surprised to
> find the script still running in it's 25th iteration this
> morning, with basically no rows left in any of the non-static tables.
>
> The interesting thing was that the data partition still had
> almost 26GB of space used, no matter how much data was
> actually in the database.

FYI: I discovered the REINDEX command, and after calling REINDEX on all non-static tables that I'd been deleting from, I got back to roughly my starting point (176MB from 26GB!).

Whoa!

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

Предыдущее
От: Tom O'Brien
Дата:
Сообщение: space not reclaimed after repeated full vacuums
Следующее
От: "Aaron Bono"
Дата:
Сообщение: Re: Wrap (obfuscate) code