On Thu, Mar 17, 2016 at 7:27 AM, Mike Blackwell <mike.blackw...@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

Reply via email to