X-Original-To: pgsql-performance-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 92A279FB1E2 for ; Thu, 10 Aug 2006 13:54:18 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 33260-06 for ; Thu, 10 Aug 2006 13:54:17 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from ausimss.pervasive.com (ausimss.pervasive.com [66.45.103.246]) by postgresql.org (Postfix) with ESMTP id 96BC29F9FAC for ; Thu, 10 Aug 2006 13:54:15 -0300 (ADT) Received: from ausbayes2.aus.pervasive.com ([172.16.8.6]) by ausimss.pervasive.com with InterScan Messaging Security Suite; Thu, 10 Aug 2006 11:54:10 -0500 Received: from AUSOWA.aus.pervasive.com ([172.16.4.8]) by ausbayes2.aus.pervasive.com with Microsoft SMTPSVC(5.0.2195.6713); Thu, 10 Aug 2006 11:54:10 -0500 Received: from ausmailid.aus.pervasive.com ([172.16.4.64]) by AUSOWA.aus.pervasive.com with Microsoft SMTPSVC(6.0.3790.1830); Thu, 10 Aug 2006 11:53:01 -0500 X-MimeOLE: Produced By Microsoft Exchange V6.5.7226.0 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Subject: Re: [BUGS] BUG #2567: High IOWAIT Date: Thu, 10 Aug 2006 11:53:01 -0500 Message-ID: <4D27CB1096EF1C408F4BFAB0046EC7B667D929@ausmailid.aus.pervasive.com> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: [BUGS] BUG #2567: High IOWAIT Thread-Index: Aca8Au5Dybq9pnYsSbaGu82slT/v4QAL/wWwABojpHA= References: <20060810043408.9C0277E40C2@smtp1.netmagicians.com> From: "Jim Nasby" To: "Kumarselvan S" Cc: X-OriginalArrivalTime: 10 Aug 2006 16:53:01.0994 (UTC) FILETIME=[711840A0:01C6BC9D] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200608/190 X-Sequence-Number: 20375 Please cc the list so others can help. How large is the database? What indexes are on the tables you're = inserting into? What speed is the drive? Since it's a single SCSI drive I'm assuming it's only 10k RPM, which = means the theoretical maximum you can hit is 160 transfers per second. = At 40 inserts per second (I'm assuming each insert is it's own = transaction), you're already at 40 WAL operations per second, minimum. = Plus whatever traffic you have to the data tables. Your biggest win would be to batch those inserts together into = transactions, if possible. If not, the commit_delay settings might help = you out. There may be some further gains to be had by tweaking the background = writer settings; it might be too aggressive in your application. That update statement could also be causing a lot of activity, depending = on what it's doing. -- Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461 -----Original Message----- From: Kumarselvan S [mailto:kumar@nexge.com] Sent: Wed 8/9/2006 11:33 PM To: Jim Nasby Subject: RE: [BUGS] BUG #2567: High IOWAIT =20 Yes , it is not a Bug.=20 Here the some Info abt the Hardware It has an SCSI Drive. It an dell made quad processor machine.=20 The changes to Postgresql.conf 1. max_connections =3D50 2. shared buffer =3D 30000 3. Temp buffer 20000 Regards, Kumar -----Original Message----- From: Jim C. Nasby [mailto:jnasby@pervasive.com]=20 Sent: Thursday, August 10, 2006 3:57 AM To: kumarselvan Cc: pgsql-performance@postgresql.org Subject: Re: [BUGS] BUG #2567: High IOWAIT This isn't a bug; moving to pgsql-performance. On Tue, Aug 08, 2006 at 08:42:02AM +0000, kumarselvan wrote: > i have installed the postgres as mentioned in the Install file. it is = a 4 > cpu 8 GB Ram Machine installed with Linux Enterprise version 3. when i = am > running a load which will perfrom 40 inserts persecond on 2 tables and = 10 > updates per 10seconds on differnt table IOWait on avg going upto 70% = due to > which i am not able to increase the load. Is there is any other way to > install the postgres on multiprocessor machine.. can any one help me = on > this... You haven't given us nearly enough information. What kind of hardware is this? RAID? What changes have you made to postgresql.conf? --=20 Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461 quad