Received: from sss.pgh.pa.us ([192.204.191.242]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f5DETiE31036 for ; Wed, 13 Jun 2001 10:29:44 -0400 (EDT) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.3/8.11.3) with ESMTP id f5DETX026285; Wed, 13 Jun 2001 10:29:33 -0400 (EDT) To: DHSC Webmaster cc: pgsql-admin@postgresql.org Subject: Re: performance issues In-reply-to: <3B276B68.2161696A@dhs-club.com> References: <3B276B68.2161696A@dhs-club.com> Comments: In-reply-to DHSC Webmaster message dated "Wed, 13 Jun 2001 09:32:24 -0400" Date: Wed, 13 Jun 2001 10:29:33 -0400 Message-ID: <26282.992442573@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200106/78 X-Sequence-Number: 1633 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