Received: from mail.ewol.com (mail.ewol.com [207.239.237.12]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f5EEl5E29014 for ; Thu, 14 Jun 2001 10:47:05 -0400 (EDT) (envelope-from webmaster@dhs-club.com) Received: from dhs-club.com [216.0.160.121] by mail.ewol.com with ESMTP (SMTPD32-6.05) id AF65FC0F0122; Thu, 14 Jun 2001 10:51:17 -0400 Message-ID: <3B28CF08.A038D9FE@dhs-club.com> Date: Thu, 14 Jun 2001 10:49:44 -0400 From: DHSC Webmaster Organization: The DHS Club X-Mailer: Mozilla 4.73 [en]C-CCK-MCD compaq (Win98; U) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Re: performance issues References: <3B276B68.2161696A@dhs-club.com> <26282.992442573@sss.pgh.pa.us> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Note: This E-mail was scanned by Declude JunkMail (www.declude.com) for spam. X-Archive-Number: 200106/86 X-Sequence-Number: 1643 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 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