Re: [GENERAL] scaling

From: "Scott V(dot) McGuire" <svmcguir(at)syr(dot)edu>
To: pgsql-general(at)postgreSQL(dot)org
Subject: Re: [GENERAL] scaling
Date: 2000-01-26 23:58:39
Message-ID: 20000126185839.A1200@syr.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)syr(dot)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/

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Graeme Merrall 2000-01-27 00:01:31 RE: [GENERAL] too many open files by postgresql backends
Previous Message Ed Loehr 2000-01-26 23:38:12 [GENERAL] too many open files by postgresql backends