>>>>> "Scott" == Scott Marlowe <scott.marlowe@xxxxxxxxx> 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@xxxxxxxxxxx> OpenPGP: 1024D/ED7DAEA6 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
