Re: When does VACUUM FULL not clean out all deleted data?

[James Cloos <cloos(at)jhcloos(dot)com>]

>>>>> "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