Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 0AA969FB656 for ; Mon, 23 Apr 2007 17:21:51 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 45840-03 for ; Mon, 23 Apr 2007 17:21:47 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from exchange.g2switchworks.com (mail.g2switchworks.com [63.87.162.25]) by postgresql.org (Postfix) with ESMTP id AEC1F9FB63F for ; Mon, 23 Apr 2007 17:21:47 -0300 (ADT) Received: from 10.10.1.37 ([10.10.1.37]) by exchange.g2switchworks.com ([10.10.1.2]) with Microsoft Exchange Server HTTP-DAV ; Mon, 23 Apr 2007 20:21:46 +0000 Received: from state.g2switchworks.com by mail.g2switchworks.com; 23 Apr 2007 15:21:46 -0500 Subject: Re: postgres: 100% CPU utilization From: Scott Marlowe To: Vivek Khera Cc: PostgreSQL Performance In-Reply-To: References: <2C20E65455FC964690D89F8C4A2E9B1D03A669CD@STRAIGHTFLUSH.cryptologic.com> <1177344544.7266.5.camel@state.g2switchworks.com> Content-Type: text/plain Content-Transfer-Encoding: 7bit Message-Id: <1177359706.15085.8.camel@state.g2switchworks.com> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 (1.4.6-2) Date: Mon, 23 Apr 2007 15:21:46 -0500 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200704/398 X-Sequence-Number: 24275 On Mon, 2007-04-23 at 15:00, Vivek Khera wrote: > On Apr 23, 2007, at 12:09 PM, Scott Marlowe wrote: > > > And do you have 32 or 64 Megs of memory in that machine? > > > > Cause honestly, 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. > > I think you're being too conservative... I recall that those specs > for me correspond to running Pg 6.5 as the latest release... talk > about performance and corruption issues... :-) He's probably got at > least a Pentium II. Yeah, now that you mention it, I think I was able to come up with a Pentium 100 with 64 Megs of RAM about the time 6.5 came out, on RedHat 5.1 then 5.2, and with a pair of 1.2 gig IDE drives under the hood. Those were the days, huh? I honestly kinda wondered if the original post came out of a time warp, like some mail relay somewhere held onto it for 4 years or something.