Postgres Pro
Downloads
Home   >   mailing lists

Re: vacuum - reclaiming disk space. - Mailing list pgsql-general

From bricklen
Subject Re: vacuum - reclaiming disk space.
Date
Msg-id CAGrpgQ-MU3PLwjztK1H-m0MirpzU+vUFchgRNt7hqRmYHiuaag@mail.gmail.com
Whole thread Raw
In response to vacuum - reclaiming disk space.  (Mike Blackwell <mike.blackwell@rrd.com>)
Responses Re: vacuum - reclaiming disk space.  (Melvin Davidson <melvin6925@gmail.com>)
List pgsql-general
Tree view
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 by date:

Previous
From: Mike Blackwell
Date:
Subject: vacuum - reclaiming disk space.
Next
From: "ray madigans.org"
Date:
Subject: Database not starting in init.d