Re: When does VACUUM FULL not clean out all deleted data? - Mailing list pgsql-admin

From Geoffrey
Subject Re: When does VACUUM FULL not clean out all deleted data?
Date
Msg-id 478264C5.9040004@serioustechnology.com
Whole thread Raw
In response to Re: When does VACUUM FULL not clean out all deleted data?  ("Joshua D. Drake" <jd@commandprompt.com>)
List pgsql-admin
Joshua D. Drake wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> On Mon, 07 Jan 2008 10:53:11 -0500
> Geoffrey <lists@serioustechnology.com> wrote:
>
>> So, I'm wondering if anyone can point me to more specific information
>> as to when, if ever, you should 'vacuum full?'
>
> 1. If you over run your fsm pages
>   * Except that vacuum full won't reclaim the index usage so use
> CLUSTER instead.
> 2. If you are only repairing bloat on a smaller table.
>   * It may be faster to backup and restore the table. Since vacuum full
> is an exclusive lock anyway it doesn't matter.

Thank you Joshua.

--
Until later, Geoffrey

Those who would give up essential Liberty, to purchase a little
temporary Safety, deserve neither Liberty nor Safety.
  - Benjamin Franklin

pgsql-admin by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: When does VACUUM FULL not clean out all deleted data?
Next
From: dr_pompeii
Date:
Subject: user login: problems in linux