Skip site navigation (1) Skip section navigation (2)

Re: [GENERAL] scaling

From: Ed Loehr <eloehr(at)austin(dot)rr(dot)com>
To: "Scott V(dot) McGuire" <svmcguir(at)syr(dot)edu>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] scaling
Date: 2000-01-27 01:15:59
Message-ID: 388F9C4F.1AB9FACD@austin.rr.com (view raw or flat)
Thread:
Lists: pgsql-general
"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

In response to

pgsql-general by date

Next:From: Fabian.FrederickDate: 2000-01-27 07:32:25
Subject: RE: [GENERAL] how to use pg-connect ?
Previous:From: Marc TardifDate: 2000-01-27 01:06:52
Subject: ERROR: heap_delete: (am)invalid tid

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group