Re: Need help in reclaiming disk space by deleting the selected records

From: Andres Freund <andres(at)2ndquadrant(dot)com>
To: pgsql-general(at)postgresql(dot)org
Cc: Steve Crawford <scrawford(at)pinpointresearch(dot)com>
Subject: Re: Need help in reclaiming disk space by deleting the selected records
Date: 2012-09-14 12:35:08
Message-ID: 201209141435.08639.andres@2ndquadrant.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Robert Sosinski 2012-09-14 12:47:54 Seeing tables with the same name on different schemas
Previous Message Albe Laurenz 2012-09-14 11:16:33 Re: application for postgres Log