Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 9267F9FC065 for ; Thu, 26 Apr 2007 22:27:16 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 88904-08 for ; Thu, 26 Apr 2007 22:27:08 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from smtp5.clear.net.nz (smtp5.clear.net.nz [203.97.33.68]) by postgresql.org (Postfix) with ESMTP id A83929FC072 for ; Thu, 26 Apr 2007 22:27:13 -0300 (ADT) Received: from [192.168.1.11] (121-72-66-191.dsl.telstraclear.net [121.72.66.191]) by smtp5.clear.net.nz (CLEAR Net Mail) with ESMTP id <0JH400MTRUPAA140@smtp5.clear.net.nz> for pgsql-performance@postgresql.org; Fri, 27 Apr 2007 13:27:12 +1200 (NZST) Date: Fri, 27 Apr 2007 13:26:53 +1200 From: Mark Kirkwood Subject: Re: postgres: 100% CPU utilization In-reply-to: <2C20E65455FC964690D89F8C4A2E9B1D03ABA7F9@STRAIGHTFLUSH.cryptologic.com> To: Sergey Tsukinovsky Cc: Ron , Mario Weilguni , pgsql-performance@postgresql.org Message-id: <4631515D.2020708@paradise.net.nz> MIME-version: 1.0 Content-type: text/plain; charset=ISO-8859-1; format=flowed Content-transfer-encoding: 7bit References: <2C20E65455FC964690D89F8C4A2E9B1D03A669CD@STRAIGHTFLUSH.cryptologic.com> <200704231053.38952.mweilguni@sime.com> <2C20E65455FC964690D89F8C4A2E9B1D03ABA7F9@STRAIGHTFLUSH.cryptologic.com> User-Agent: Thunderbird 1.5.0.10 (X11/20070313) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200704/449 X-Sequence-Number: 24326 Sergey Tsukinovsky wrote: > > Just for the record - the hardware that was used for the test has the > following parameters: > AMD Opteron 2GHZ > 2GB RAM > LSI Logic SCSI > And you ran FreeBSD 4.4 on it right? This may be a source of high cpu utilization in itself if the box is SMP or dual core, as multi-cpu support was pretty primitive in that release (4.12 would be better if you are required to stick to the 4.x branch, if not the 6.2 is recommended)! Cheers Mark