From: DHSC Webmaster <webmaster@dhs-club.com>
To: pgsql-admin@postgresql.org
Subject: Re: performance issues
Date: Thu, 14 Jun 2001 10:49:44 -0400
Message-ID: <3B28CF08.A038D9FE@dhs-club.com> (raw)
References: <3B276B68.2161696A@dhs-club.com>
<26282.992442573@sss.pgh.pa.us>
Thank you Tom. That has seemed to help substantially.
I received another sugestion to increase -B 30000 which would give 240
meg. to postgres. I plan to give that a try. I've already reset the
SHMMAX val in sysctl to accomodate that size. Do you see any reason not
to try this? My thought is if some is good, more must be better. :)
Also I noticed in this artice:
http://www.ca.postgresql.org/docs/faq-english.html#3.7
mention of another memory parameter (-S), however the elephant book
refers to -S as silent mode.
Could you clarify this?
Tom Lane wrote:
>
> 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
--
Bill MacArthur
Webmaster
DHS Club
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: webmaster@dhs-club.com, pgsql-admin@postgresql.org
Subject: Re: performance issues
In-Reply-To: <3B28CF08.A038D9FE@dhs-club.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox