X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id A2EAAD1D7BD for ; Wed, 19 Nov 2003 01:20:48 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 52268-09 for ; Tue, 18 Nov 2003 21:20:20 -0400 (AST) Received: from mail.viatornetworks.com (unknown [216.224.225.50]) by svr1.postgresql.org (Postfix) with ESMTP id 85822D1D674 for ; Tue, 18 Nov 2003 21:20:15 -0400 (AST) Received: from [10.1.0.6] (216-224-225-54.phxinternet.net [216.224.225.54] (may be forged)) by mail.viatornetworks.com (8.9.3/8.9.3) with ESMTP id SAA09099 for ; Tue, 18 Nov 2003 18:20:02 -0700 Subject: High Processor consumption From: Benjamin Bostow To: pgsql-performance@postgresql.org Content-Type: text/plain Content-Transfer-Encoding: 7bit X-Mailer: Ximian Evolution 1.0.8 (1.0.8-11) Date: 18 Nov 2003 18:19:14 -0700 Message-Id: <1069204784.1955.16.camel@localhost.localdomain> Mime-Version: 1.0 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200311/147 X-Sequence-Number: 4707 I am running RH 7.3 running Apache 1.3.27-2 and PostgreSQL 7.2.3-5.73. When having 100+ users connected to my server I notice that postmaster consumes up wards of 90% of the processor and I hardly am higher than 10% idle. I did notice that when I kill apache and postmaster that my idle processor percentage goes to 95% or higher. I am looking on ways that I can find what connections are making the database processes run so high. If this could also tell which program is accessing it, it would be helpful. I have look through the documents on performance tuning postgresql and have adjusted my memory with little effect. I have even routed all traffic away from the Apache server so no load is on apache. I do have C programs that run and access the database. Any help will be greatly appreciated. Thanks in advance, Ben