>>>>> "Scott" == Scott Marlowe <scott.marlowe@gmail.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@jhcloos.com> OpenPGP: 1024D/ED7DAEA6
