Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id BE9299FB581 for ; Mon, 23 Apr 2007 20:59:35 -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 53441-03 for ; Mon, 23 Apr 2007 20:59:27 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from smtp3.clear.net.nz (smtp3.clear.net.nz [203.97.33.64]) by postgresql.org (Postfix) with ESMTP id 781839FB559 for ; Mon, 23 Apr 2007 20:59:32 -0300 (ADT) Received: from [192.168.1.11] (121-72-75-223.dsl.telstraclear.net [121.72.75.223]) by smtp3.clear.net.nz (CLEAR Net Mail) with ESMTP id <0JGZ00CG86N57Q10@smtp3.clear.net.nz> for pgsql-performance@postgresql.org; Tue, 24 Apr 2007 11:59:30 +1200 (NZST) Date: Tue, 24 Apr 2007 11:59:12 +1200 From: Mark Kirkwood Subject: Re: postgres: 100% CPU utilization In-reply-to: <1177344544.7266.5.camel@state.g2switchworks.com> To: Scott Marlowe Cc: Sergey Tsukinovsky , pgsql-performance@postgresql.org Message-id: <462D4850.106@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> <1177344544.7266.5.camel@state.g2switchworks.com> User-Agent: Thunderbird 1.5.0.10 (X11/20070313) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200704/399 X-Sequence-Number: 24276 Scott Marlowe wrote: > (snippage) that's the kinda hardware I was running 7.0.2 on, so you > might as well get retro in your hardware department while you're at it. > Notice he's running FreeBSD 4.4(!), so it could well be a very old machine... Cheers Mark