Re: vacuum - reclaiming disk space.

Поиск
Список
Период
Сортировка
От bricklen
Тема Re: vacuum - reclaiming disk space.
Дата
Msg-id CAGrpgQ-MU3PLwjztK1H-m0MirpzU+vUFchgRNt7hqRmYHiuaag@mail.gmail.com
обсуждение исходный текст
Ответ на vacuum - reclaiming disk space.  (Mike Blackwell <mike.blackwell@rrd.com>)
Ответы Re: vacuum - reclaiming disk space.  (Melvin Davidson <melvin6925@gmail.com>)
Список pgsql-general
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?

pg_repack is a good tool for removing bloat. https://github.com/reorg/pg_repack

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

Предыдущее
От: Mike Blackwell
Дата:
Сообщение: vacuum - reclaiming disk space.
Следующее
От: "ray madigans.org"
Дата:
Сообщение: Database not starting in init.d