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 39F87D1B241 for ; Tue, 29 Jun 2004 13:17:53 -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 64612-08 for ; Tue, 29 Jun 2004 16:17:44 +0000 (GMT) Received: from mproxy.gmail.com (mproxy.gmail.com [216.239.56.242]) by svr1.postgresql.org (Postfix) with SMTP id CEE2CD1B187 for ; Tue, 29 Jun 2004 13:17:42 -0300 (ADT) Received: by mproxy.gmail.com with SMTP id u22so421691cwc for ; Tue, 29 Jun 2004 09:17:36 -0700 (PDT) Received: by 10.38.181.22 with SMTP id d22mr43514rnf; Tue, 29 Jun 2004 09:17:36 -0700 (PDT) Message-ID: <9662496504062909172bf8034b@mail.gmail.com> Date: Tue, 29 Jun 2004 09:17:36 -0700 From: Marc To: "eleven@ludojad.itpp.pl" Subject: Re: High load average with PostgreSQL 7.4.2 on debian/ibm eserver. Cc: pgsql-performance@postgresql.org In-Reply-To: <20040629155537.GA5465@ludojad.itpp.pl> Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit References: <20040629155537.GA5465@ludojad.itpp.pl> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests=TO_ADDRESS_EQ_REAL X-Spam-Level: X-Archive-Number: 200406/304 X-Sequence-Number: 7362 On Tue, 29 Jun 2004 17:55:37 +0200, eleven@ludojad.itpp.pl wrote: > Performance issue, I'm experiencing here, is somewhat > weird - server gets high average load (from 5 up to 15, > 8 on average). Standard performance monitoring > utilities (like top) show that CPUs are not loaded > (below 20%, often near zero). So ... you never actually say what the performance issue you experience is. Having a high load average is not necessarily a performance issue. What is it that you want to fix?