Re: [GENERAL] scaling - Mailing list pgsql-general

From Scott V. McGuire
Subject Re: [GENERAL] scaling
Date
Msg-id 20000126185839.A1200@syr.edu
Whole thread Raw
In response to Re: [GENERAL] scaling  (Ed Loehr <eloehr@austin.rr.com>)
List pgsql-general
On Wed, Jan 26, 2000 at 04:51:26PM -0600, Ed Loehr 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.
>
> Cheers,
> Ed Loehr
>

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?

--
Scott V. McGuire <svmcguir@syr.edu>
GnuPG key available at http://physics.syr.edu/~svmcguir
GnuPG key fingerprint: 21EA 4999 3620 3E1D 71EC  98A9 5B9B EF52 1258 6D53
GnuPG is at http://www.gnupg.org/


pgsql-general by date:

Previous
From: Ed Loehr
Date:
Subject: [GENERAL] too many open files by postgresql backends
Next
From: "Graeme Merrall"
Date:
Subject: RE: [GENERAL] too many open files by postgresql backends