From: | Geoffrey <lists(at)serioustechnology(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: When does VACUUM FULL not clean out all deleted data? |
Date: | 2008-01-07 17:43:33 |
Message-ID: | 478264C5.9040004@serioustechnology.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Joshua D. Drake wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> On Mon, 07 Jan 2008 10:53:11 -0500
> Geoffrey <lists(at)serioustechnology(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | dr_pompeii | 2008-01-08 04:26:08 | user login: problems in linux |
Previous Message | Joshua D. Drake | 2008-01-07 17:12:11 | Re: When does VACUUM FULL not clean out all deleted data? |