Re: performance issues - Mailing list pgsql-admin

From Tom Lane
Subject Re: performance issues
Date
Msg-id 26282.992442573@sss.pgh.pa.us
Whole thread Raw
In response to performance issues  (DHSC Webmaster <webmaster@dhs-club.com>)
List pgsql-admin
DHSC Webmaster <webmaster@dhs-club.com> writes:
> We are running 7.0.3 on a RH 7.0 box w/twin 733 pentium CPUs, 512 meg.
> ram and a 3 drive raid 5 scsi array. The machine is dedicated. Our main
> table is about 700,000 rows with an associated table of about 15,000
> rows.
> -N 128 -B 256

That's not nearly enough buffers for an installation that size.  Try -B
of a few thousand.

            regards, tom lane

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: User rights
Next
From: Tom Lane
Date:
Subject: Re: User rights