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

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