X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id B6F22D1B33F for ; Mon, 28 Jun 2004 13:49:27 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 76180-06 for ; Mon, 28 Jun 2004 16:49:23 +0000 (GMT) Received: from davinci.ethosmedia.com (server228.ethosmedia.com [209.128.84.228]) by svr1.postgresql.org (Postfix) with ESMTP id D0C4ED1B2D9 for ; Mon, 28 Jun 2004 13:49:21 -0300 (ADT) Received: from [63.195.55.98] (HELO spooky) by davinci.ethosmedia.com (CommuniGate Pro SMTP 4.1.8) with ESMTP id 5531585; Mon, 28 Jun 2004 09:51:03 -0700 Content-Type: text/plain; charset="iso-8859-1" From: Josh Berkus Organization: Aglio Database Solutions To: Tom Lane , Frank Knobbe Subject: Re: postgres 7.4 at 100% Date: Mon, 28 Jun 2004 09:47:59 -0700 User-Agent: KMail/1.4.3 Cc: pgsql-performance@postgresql.org References: <1088397641.1105.10.camel@localhost> <17884.1088399982@sss.pgh.pa.us> In-Reply-To: <17884.1088399982@sss.pgh.pa.us> MIME-Version: 1.0 Content-Transfer-Encoding: 8bit Message-Id: <200406280947.59420.josh@agliodbs.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200406/275 X-Sequence-Number: 7333 Tom, > So while he surely should not go back to 40, it seems there's another > factor involved here that we've not recognized yet. I'd agree. Actually, the first thing I'd do, were it my machine, is reboot it and run memtest86 overnight. CPU thrashing like that may indicate bad RAM. If the RAM checks out, I'd like to see the EXPLAIN ANALYZE for some of the longest-running queries, and for those INSERTS. Also, is the new machine running Software RAID? -- Josh Berkus Aglio Database Solutions San Francisco