| From: | Steve Crawford <scrawford(at)pinpointresearch(dot)com> |
|---|---|
| To: | Andres Freund <andres(at)2ndquadrant(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Need help in reclaiming disk space by deleting the selected records |
| Date: | 2012-09-14 14:34:02 |
| Message-ID: | 5053405A.3070503@pinpointresearch.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 09/14/2012 05:35 AM, Andres Freund wrote:
> 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.
>
>
That's true - I should have pointed that out. But it also means that you
can get into a corner if you need to vacuum full large tables when you
have limited free disk space - something the OP should consider since
reclaiming disk space was one of his motivations.
Cheers,
Steve
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ivan Voras | 2012-09-14 15:20:11 | Custom integer-like type |
| Previous Message | Albe Laurenz | 2012-09-14 14:29:55 | Re: PL/pgSQL debugger and PostgreSQL 9.2 |