X-Original-To: pgsql-performance-postgresql.org@postgresql.org Received: from localhost (unknown [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 8CD359FAA6E for ; Wed, 30 Aug 2006 08:37:10 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 20343-01-6 for ; Wed, 30 Aug 2006 08:37:00 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from relay01.is.co.za (relay01.is.co.za [196.35.6.69]) by postgresql.org (Postfix) with ESMTP id B9AEC9FA61D for ; Wed, 30 Aug 2006 08:35:30 -0300 (ADT) Received: from relay01.is.co.za (localhost [127.0.0.1]) by relay01.is.co.za (Postfix) with ESMTP id BDF043159C8 for ; Wed, 30 Aug 2006 13:35:28 +0200 (SAST) Received: from smtp02.isdsl.net (smtp02.isdsl.net [196.26.208.200]) by relay01.is.co.za (Postfix) with ESMTP id A3A4B3158EF for ; Wed, 30 Aug 2006 13:35:28 +0200 (SAST) Received: from server.svo.co.za (c1-52-10.rrba.isadsl.co.za [196.209.57.52]) by smtp02.isdsl.net (Postfix) with ESMTP id 630F42E1D7 for ; Wed, 30 Aug 2006 13:35:28 +0200 (SAST) Received: from [192.168.0.11] ([192.168.0.11]) by server.svo.co.za with Microsoft SMTPSVC(6.0.3790.1830); Wed, 30 Aug 2006 13:39:49 +0200 Message-ID: <44F577F8.5070307@studentvillage.co.za> Date: Wed, 30 Aug 2006 13:35:20 +0200 From: Willo van der Merwe User-Agent: Thunderbird 1.5.0.5 (Windows/20060719) MIME-Version: 1.0 To: Luke Lonergan Cc: Merlin Moncure , pgsql-performance@postgresql.org Subject: Re: PostgreSQL performance issues References: <3E37B936B592014B978C4415F90D662D04392D1A@MI8NYCMAIL06.Mi8.com> In-Reply-To: <3E37B936B592014B978C4415F90D662D04392D1A@MI8NYCMAIL06.Mi8.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-OriginalArrivalTime: 30 Aug 2006 11:39:49.0890 (UTC) FILETIME=[0063BE20:01C6CC29] X-Virus-Scanned: ClamAV using ClamSMTP at relay01.dial-up.net X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.035 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO, ROUND_THE_WORLD X-Spam-Level: * X-Archive-Number: 200608/469 X-Sequence-Number: 20654 Luke Lonergan wrote: >> Currently the load looks like this: >> Cpu0 : 96.8% us, 1.9% sy, 0.0% ni, 0.3% id, 0.0% wa, >> 0.0% hi, 1.0% si >> Cpu1 : 97.8% us, 1.6% sy, 0.0% ni, 0.3% id, 0.0% wa, >> 0.0% hi, 0.3% si >> Cpu2 : 96.8% us, 2.6% sy, 0.0% ni, 0.3% id, 0.0% wa, >> 0.0% hi, 0.3% si >> Cpu3 : 96.2% us, 3.2% sy, 0.0% ni, 0.3% id, 0.0% wa, >> 0.0% hi, 0.3% si >> > > All four CPUs are hammered busy - check "top" and look for runaway > processes. > > - Luke > > > Yes, the first 463 process are all postgres. In the meanwhile I've done: Dropped max_connections from 500 to 250 and Upped shared_buffers = 50000 Without any apparent effect.