"Matt Friedman" <matt@daart.ca> writes:
> 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?
If you can spare the cycles, you might as well make every vacuum a
vacuum analyze.
regards, tom lane