Received: from mail.ewol.com (mail.ewol.com [207.239.237.12]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f5DDTjE64103 for ; Wed, 13 Jun 2001 09:29:45 -0400 (EDT) (envelope-from webmaster@dhs-club.com) Received: from dhs-club.com [216.0.160.116] by mail.ewol.com with ESMTP (SMTPD32-6.05) id ABC5A96700E2; Wed, 13 Jun 2001 09:33:57 -0400 Message-ID: <3B276B68.2161696A@dhs-club.com> Date: Wed, 13 Jun 2001 09:32:24 -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: performance issues 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/76 X-Sequence-Number: 1631 Hello all, 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 logging to a file Without spelling out our complete schema I'll give some basic info main table has 37 columns with 3 indexes, several foreign key constraints and one rule the associated table has about 10 columns all or which are int 4 with the exception of one text Most of our queries are simple select queries, half of which would use the indexes. Now, does this scenario sound about right or do I have a lot of work to do? At any given moment having 12 - 16 queries running (say 1 update & one insert, the rest selects), I'm dragging bad. Vacuum -z was just run. top gives me numbers around 20. Even with just a 2 or 3 queries running top gives me 2 - 3. Does this sound typical? If my information is insufficient to give a ballpark quess, perhaps you could give me some normal types of performance figures. Thank you for your feedback. -- Bill MacArthur Webmaster DHS Club