Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 1385F9FBC5F for ; Thu, 12 Apr 2007 02:17:28 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 42583-03 for ; Thu, 12 Apr 2007 02:17:16 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from mxfep03.bredband.com (mxfep03.bredband.com [195.54.107.76]) by postgresql.org (Postfix) with ESMTP id 963959FBBBF for ; Thu, 12 Apr 2007 01:56:10 -0300 (ADT) Received: from ironport.bredband.com ([195.54.107.82] [195.54.107.82]) by mxfep01.bredband.com with ESMTP id <20070412043421.RDPC3634.mxfep01.bredband.com@ironport.bredband.com> for ; Thu, 12 Apr 2007 06:34:21 +0200 Received: from ua-83-227-204-174.cust.bredbandsbolaget.se (HELO zigo.dhs.org) ([83.227.204.174]) by ironport.bredband.com with ESMTP; 12 Apr 2007 06:34:19 +0200 Received: from [192.168.0.3] (cosmo.zigo.dhs.org [192.168.0.3]) by zigo.dhs.org (Postfix) with ESMTP id 514B48640; Thu, 12 Apr 2007 06:34:14 +0200 (CEST) Message-ID: <461DB6C6.5010207@zigo.dhs.org> Date: Thu, 12 Apr 2007 06:34:14 +0200 From: Dennis Bjorklund User-Agent: Thunderbird 1.5.0.10 (X11/20070302) MIME-Version: 1.0 To: Jason Lustig Cc: pgsql-performance@postgresql.org Subject: Re: Slow Postgresql server References: <57271CC2-BCB1-4ACA-A177-4FF64F1BC33F@brandeis.edu> In-Reply-To: <57271CC2-BCB1-4ACA-A177-4FF64F1BC33F@brandeis.edu> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200704/248 X-Sequence-Number: 24125 Jason Lustig skrev: > and work_mem to 8096. What would cause the computer to only use such a > small percentage of the CPU, with more than half of it waiting on I/O > requests? Do your webpages write things to the database on each connect? Maybe it do a bunch of writes each individually commited? For every commit pg will wait for the data to be written down to the disk platter before it move on. So if you do several writes you want to do them in one transaction so you only need one commit. /Dennis