Justin Long <justinlong(at)strategicnetwork(dot)org> writes:
> Wow. I can't believe the difference. It didn't take too long. I'll set up a
> script in my etc/cron.weekly to run it... would there be any benefit to
> doing a vacuum analyze nightly?
Depends. A nightly vacuum is probably good practice, but you could skip
the analyze part if your data statistics (such as column min and max
values) don't change much.
regards, tom lane