X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 94241D1B196 for ; Tue, 29 Jun 2004 19:36:00 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 63150-05 for ; Tue, 29 Jun 2004 22:36:01 +0000 (GMT) Received: from mpls-qmqp-04.inet.qwest.net (mpls-qmqp-04.inet.qwest.net [63.231.195.115]) by svr1.postgresql.org (Postfix) with SMTP id E56AED1B1CD for ; Tue, 29 Jun 2004 19:35:56 -0300 (ADT) Received: (qmail 88598 invoked by uid 0); 29 Jun 2004 22:35:59 -0000 Received: from mpls-pop-04.inet.qwest.net (63.231.195.4) by mpls-qmqp-04.inet.qwest.net with QMQP; 29 Jun 2004 22:35:59 -0000 Received: from 63-227-127-37.dnvr.qwest.net (HELO ?10.0.0.2?) (63.227.127.37) by mpls-pop-04.inet.qwest.net with SMTP; 29 Jun 2004 22:35:59 -0000 Date: Tue, 29 Jun 2004 16:36:55 -0600 Message-Id: <1088548615.12350.44.camel@localhost.localdomain> From: "Scott Marlowe" To: eleven@ludojad.itpp.pl Cc: pgsql-performance@postgresql.org Subject: Re: High load average with PostgreSQL 7.4.2 on In-Reply-To: <20040629155537.GA5465@ludojad.itpp.pl> References: <20040629155537.GA5465@ludojad.itpp.pl> Content-Type: text/plain Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 (1.4.6-2) Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.1 tagged_above=0.0 required=5.0 tests=RCVD_IN_SORBS X-Spam-Level: X-Archive-Number: 200406/315 X-Sequence-Number: 7373 On Tue, 2004-06-29 at 09:55, eleven@ludojad.itpp.pl wrote: > Hello, > > I'm using PostgreSQL 7.4.2 (package from backports.org) > on a Debian (woody) box. The machine is IBM eServer 345 > with two 2.8 Xeon CPUs, it has 1024MB of RAM and > two 15k RPM SCSI disks running in hardware RAID1, which > is provided by the onboard LSI Logic controller (LSI53C1030). > > The database consists of two rather large tables > (currently about 15 million rows in one table > and about 5 million in the other one). Both tables > have 5 indexes (4 btree/1 hash). > Application running on the server INSERTs a lot of > stuff to the tables (which is not the target use of > the DB, it'll add data periodically, about > 300 rows per 10 minutes). Queries (SELECTs) run perfectly > fine on the database, thanks to the indexes we have > here probably. > > Performance issue, I'm experiencing here, is somewhat > weird - server gets high average load (from 5 up to 15, > 8 on average). Standard performance monitoring > utilities (like top) show that CPUs are not loaded > (below 20%, often near zero). Anytime you have high load but low CPU utilization, you usually have an I/O bound system. Ad disks to your RAID (big RAID 5 or RAID 1+0) and make sure you have battery backed cache set to write back. also, put as memory as you can in the machine. Jumping up to 2 Gigs may help quite a bit as well.