Re: vacuum - reclaiming disk space.

From: bricklen <bricklen(at)gmail(dot)com>
To: Mike Blackwell <mike(dot)blackwell(at)rrd(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: vacuum - reclaiming disk space.
Date: 2016-03-17 14:57:04
Message-ID: CAGrpgQ-MU3PLwjztK1H-m0MirpzU+vUFchgRNt7hqRmYHiuaag@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Mar 17, 2016 at 7:27 AM, Mike Blackwell <mike(dot)blackwell(at)rrd(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message ray madigans.org 2016-03-17 15:20:02 Database not starting in init.d
Previous Message Mike Blackwell 2016-03-17 14:27:33 vacuum - reclaiming disk space.