vacuum - reclaiming disk space.

From: Mike Blackwell <mike(dot)blackwell(at)rrd(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: vacuum - reclaiming disk space.
Date: 2016-03-17 14:27:33
Message-ID: CANPAkgu9d8iFc_b6PdFSJ2i2BtEV0XbJ24E3KsgJfMLUSifLeg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

* <Mike(dot)Blackwell(at)rrd(dot)com>*

Responses

Browse pgsql-general by date

  From Date Subject
Next Message bricklen 2016-03-17 14:57:04 Re: vacuum - reclaiming disk space.
Previous Message Adrian Klaver 2016-03-17 14:23:19 Re: Insert data in two columns same table