Been reading a number of the posts regarding vacuum and vacuum analyze.
I currently running vacuum nighly using cron and once in a while I run
vacuum analyze (as postgres).
Any reason why I wouldn't just simply run vacuum analyze each night?
Matt Friedman
Spry New Media
http://www.sprynewmedia.com
Lead Programmer/Partner
email: matt@sprynewmedia.com
phone: 250 744 3655
fax: 250 370 0436