Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 57A309FC0C9 for ; Wed, 9 May 2007 10:49:46 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 43538-02 for ; Wed, 9 May 2007 10:49:31 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from orthanc.site5.com (orthanc.site5.com [64.21.68.2]) by postgresql.org (Postfix) with ESMTP id 924C49FC082 for ; Wed, 9 May 2007 10:49:36 -0300 (ADT) Received: from pool-71-124-169-145.bstnma.east.verizon.net ([71.124.169.145] helo=[192.168.1.8]) by orthanc.site5.com with esmtpsa (TLSv1:AES256-SHA:256) (Exim 4.52) id 1HlmXo-0006eM-SE for pgsql-performance@postgresql.org; Wed, 09 May 2007 09:49:29 -0400 Mime-Version: 1.0 Message-Id: In-Reply-To: <20070509055655.D4C24DCC04A@svr2.hagander.net> References: <20070509055655.D4C24DCC04A@svr2.hagander.net> Date: Wed, 9 May 2007 09:49:31 -0400 To: pgsql-performance@postgresql.org From: Daniel Griscom Subject: Re: Throttling PostgreSQL's CPU usage Content-Type: text/plain; charset="us-ascii" ; format="flowed" X-Antivirus-Scanner: This message has been scanned by ClamAV. X-AntiAbuse: This header was added to track abuse, please include it with any abuse report X-AntiAbuse: Primary Hostname - orthanc.site5.com X-AntiAbuse: Original Domain - postgresql.org X-AntiAbuse: Originator/Caller UID/GID - [0 0] / [47 12] X-AntiAbuse: Sender Address Domain - suitable.com X-Source: X-Source-Args: X-Source-Dir: X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.038 tagged_above=0 required=5 tests=AWL=1.148, BAYES_05=-1.11 X-Spam-Level: X-Archive-Number: 200705/188 X-Sequence-Number: 24578 Thanks again for all the feedback. Running on a dual processor/core machine is clearly a first step, and I'll look into the other suggestions as well. Thanks, Dan -- Daniel T. Griscom griscom@suitable.com Suitable Systems http://www.suitable.com/ 1 Centre Street, Suite 204 (781) 665-0053 Wakefield, MA 01880-2400