Re: [GENERAL] scaling

"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