"Scott V. McGuire" wrote:
>
> > See http://www.deja.com/getdoc.xp?AN=563958392
> >
> > I suspect vacuum also would have a dramatic impact on performance in
> > your test case.
>
> Ok, well there's at least two things I should have said. I am running
> with -F and I did a vacuum analyze last night. Does vacuum analyze do
> the analyze stuff in addition to or instead of the plain vacuum stuff?
In addition, I believe.
It also occurred to me that it probably doesn't really matter how much
*time* has passed since your last vacuum, but rather how much
*activity* (ie., inserts/deletes) has occurred since you last
vacuumed...
Cheers,
Ed Loehr