vacuum vs pg_repack for clearing bloat?

From: Lists <lists(at)benjamindsmith(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: vacuum vs pg_repack for clearing bloat?
Date: 2014-01-16 00:09:28
Message-ID: 52D72338.4070908@benjamindsmith.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2014-01-16 00:24:02 Re: vacuum vs pg_repack for clearing bloat?
Previous Message Torsten Förtsch 2014-01-15 20:40:36 Is http://www.postgresql.org/docs/9.3/static/row-estimation-examples.html up to date?