| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Fabian.Frederick | 2000-01-27 07:32:25 | RE: [GENERAL] how to use pg-connect ? |
| Previous Message | Marc Tardif | 2000-01-27 01:06:52 | ERROR: heap_delete: (am)invalid tid |