vacuum vs pg_repack for clearing bloat?

Поиск
Список
Период
Сортировка
Our app makes extensive use of temp tables, and this causes a
significant amount of bloat that can often only be cleared with a manual
vacuum process. We're looking for a better way that doesn't involve
locking, we found pg_repack and pg_reorg  and were wondering if anybody
here could weigh in on using this instead of using vacuum?

pg_repack:
https://github.com/reorg/pg_repack

pg_reorg
http://reorg.projects.pgfoundry.org/

Thanks in advance,

Ben


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

Предыдущее
От: Torsten Förtsch
Дата:
Сообщение: Is http://www.postgresql.org/docs/9.3/static/row-estimation-examples.html up to date?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: vacuum vs pg_repack for clearing bloat?