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

From Mike Blackwell
Subject vacuum - reclaiming disk space.
Date
Msg-id CANPAkgu9d8iFc_b6PdFSJ2i2BtEV0XbJ24E3KsgJfMLUSifLeg@mail.gmail.com
Whole thread Raw
Responses Re: vacuum - reclaiming disk space.  (bricklen <bricklen@gmail.com>)
Re: vacuum - reclaiming disk space.  (Chris Travers <chris.travers@gmail.com>)
List 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?


pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Insert data in two columns same table
Next
From: bricklen
Date:
Subject: Re: vacuum - reclaiming disk space.