From: | James Cloos <cloos(at)jhcloos(dot)com> |
---|---|
To: | "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com> |
Cc: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-admin(at)postgresql(dot)org |
Subject: | Re: When does VACUUM FULL not clean out all deleted data? |
Date: | 2008-01-05 17:28:27 |
Message-ID: | m38x34chc4.fsf@lugabout.jhcloos.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
>>>>> "Scott" == Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> writes:
Scott> Note that routine vacuum FULL is not a good idea actually.
Scott> vacuum full is something you run when things have gone wrong
Scott> (i.e. not enough regular vacuuming) and it is usually best
Scott> followed by reindexing all your indexes.
I see.
Scott> It's far better to keep track of bloat and run vacuum full, if at
Scott> all, by hand, and only when needed. Running it regularly with no
Scott> reindexing often results in index bloat which makes the database
Scott> slower not faster.
That, then, probably explains the extra five gigs. There are quite a
few indices in the app's schema.
Thanks.
-JimC
--
James Cloos <cloos(at)jhcloos(dot)com> OpenPGP: 1024D/ED7DAEA6
From | Date | Subject | |
---|---|---|---|
Next Message | Geoffrey | 2008-01-07 15:53:11 | Re: When does VACUUM FULL not clean out all deleted data? |
Previous Message | James Cloos | 2008-01-05 17:24:37 | Re: When does VACUUM FULL not clean out all deleted data? |