Postgres Pro
Downloads
Home   >   mailing lists

Re: Need help in reclaiming disk space by deleting the selected records - Mailing list pgsql-general

From Andres Freund
Subject Re: Need help in reclaiming disk space by deleting the selected records
Date
Msg-id 201209141435.08639.andres@2ndquadrant.com
Whole thread Raw
In response to Re: Need help in reclaiming disk space by deleting the selected records  (Steve Crawford <scrawford@pinpointresearch.com>)
Responses Re: Need help in reclaiming disk space by deleting the selected records  (Steve Crawford <scrawford@pinpointresearch.com>)
List pgsql-general
Tree view 
Hi,

On Friday, September 14, 2012 01:29:59 AM Steve Crawford wrote:
> 2. CLUSTER is typically way faster than VACUUM FULL and rebuilds the
> indexes as well but it temporarily requires sufficient disk-space to
> write out a copy of the table being clustered.
Thats not the case anymore since 9.0 btw. These days VACUUM FULL does the same
thing CLUSTER does just without sorting.

Greetings,

Andres
--
 Andres Freund                       http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services

pgsql-general by date:

Previous
From: "Albe Laurenz"
Date:
Subject: Re: application for postgres Log
Next
From: Robert Sosinski
Date:
Subject: Seeing tables with the same name on different schemas