"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
In response to
pgsql-general by date
|Next:||From: Fabian.Frederick||Date: 2000-01-27 07:32:25|
|Subject: RE: [GENERAL] how to use pg-connect ?|
|Previous:||From: Marc Tardif||Date: 2000-01-27 01:06:52|
|Subject: ERROR: heap_delete: (am)invalid tid|