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 F2D5ED1B1C9 for ; Fri, 25 Jun 2004 03:59:48 -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 27523-06 for ; Fri, 25 Jun 2004 06:59:42 +0000 (GMT) Received: from mproxy.gmail.com (mproxy.gmail.com [216.239.56.244]) by svr1.postgresql.org (Postfix) with SMTP id 59E24D1B7D1 for ; Fri, 25 Jun 2004 03:59:32 -0300 (ADT) Received: by mproxy.gmail.com with SMTP id w29so5698868cwb for ; Thu, 24 Jun 2004 23:59:32 -0700 (PDT) Received: by 10.38.164.51 with SMTP id m51mr49212rne; Thu, 24 Jun 2004 23:59:32 -0700 (PDT) Message-ID: Date: Thu, 24 Jun 2004 23:59:32 -0700 From: Chris Cheston To: pgsql-performance@postgresql.org Subject: postgres 7.4 at 100% Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit 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/254 X-Sequence-Number: 7312 Hi all, I was running Postgres 7.3 and it was running at about 15% with my application. On Postgres 7.4 on another box, it was running at 100%... My settings are default on both boxes I think. There are only about 20 inserts per second, which is really low. Anyone have any ideas as to something I have to do to Postgres 7.4 to change it from the default so that it's not eating up all my CPU? I have no clue how to debug this... Help please!!!! Should I downgrade to 7.3 to see what happens? BTW I'm running Postgres 7.3.2 on: Linux box 2.4.25-040218 #1 SMP Wed Feb 18 17:59:29 CET 2004 i686 i686 i386 GNU/Linux on a single processor P4 1.4GHz, 512 MB RAM. Does the SMP kernel do something with the single processor CPU? or should this not affect psql? Thanks in advance!!! Chris