Re: vacuum - reclaiming disk space.

Поиск
Список
Период
Сортировка
От Chris Travers
Тема Re: vacuum - reclaiming disk space.
Дата
Msg-id CAKt_ZfvkmK_cuU-oKMY7Q5FgHP5wA_LAMB7_Q+-pbvmj7yLCKg@mail.gmail.com
обсуждение исходный текст
Ответ на vacuum - reclaiming disk space.  (Mike Blackwell <mike.blackwell@rrd.com>)
Список pgsql-general
Дерево обсуждения
Autovacuum will eventually free your extra pages regarding index bloat but it takes multiple runs.

You could also use reindex instead of vacuum full since you are only interested in the index.

For the table there may be other options but they depend on your pattern of writes.

On Thu, Mar 17, 2016 at 7:27 AM, Mike Blackwell <mike.blackwell@rrd.com> wrote:
I have a large table with numerous indexes which has approximately doubled in size after adding a column - every row was rewritten and 50% of the tuples are dead.  I'd like to reclaim this space, but VACUUM FULL cannot seem to finish within the scheduled downtime.

Any suggestions for reclaiming the space without excessive downtime?





--
Best Wishes,
Chris Travers

Efficito:  Hosted Accounting and ERP.  Robust and Flexible.  No vendor lock-in.

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

Предыдущее
От: Robert McAlpine
Дата:
Сообщение: Re: vacuum - reclaiming disk space.
Следующее
От: Steve Kehlet
Дата:
Сообщение: which db caused postgres to stop serving due to wraparound prevention?