X-Original-To: pgsql-performance-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id A02A39FB310 for ; Wed, 30 Aug 2006 11:49:21 -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 35682-06 for ; Wed, 30 Aug 2006 11:49:08 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from smtp01.isdsl.net (smtp01.isdsl.net [196.26.208.190]) by postgresql.org (Postfix) with ESMTP id 4DB229FB303 for ; Wed, 30 Aug 2006 11:49:08 -0300 (ADT) Received: from server.svo.co.za (c1-52-10.rrba.isadsl.co.za [196.209.57.52]) by smtp01.isdsl.net (Postfix) with ESMTP id 6CB142EE9E for ; Wed, 30 Aug 2006 16:49:05 +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 16:53:32 +0200 Message-ID: <44F5A559.9050701@studentvillage.co.za> Date: Wed, 30 Aug 2006 16:48:57 +0200 From: Willo van der Merwe User-Agent: Thunderbird 1.5.0.5 (Windows/20060719) MIME-Version: 1.0 To: Dave Dutcher Cc: pgsql-performance@postgresql.org Subject: Re: PostgreSQL performance issues References: <007501c6cc3d$01e1e290$8300a8c0@tridecap.com> In-Reply-To: <007501c6cc3d$01e1e290$8300a8c0@tridecap.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-OriginalArrivalTime: 30 Aug 2006 14:53:32.0921 (UTC) FILETIME=[10418690:01C6CC44] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.36 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200608/478 X-Sequence-Number: 20663 Dave Dutcher wrote: > That's an interesting situation. Your CPU's are pegged, and you're > hardly doing any IO. I wonder if there is some ineficient query, or > if its just very high query volume. Maybe you could try setting > log_min_duration_statement to try to track down the slowest of the > queries. Then post the slow queries with an explain analyze to the list. > > Here is some info on setting up logging: > http://www.postgresql.org/docs/8.1/interactive/runtime-config-logging.html > > Are your queries standard SQL or do you call functions you wrote in > PL/pgSQl or PL/Python or anything? > > It might be a combo of queries and load. My queries use almost exclusively functions, but on an unloaded dev machine performs its queries in aprox 10ms. When is it appropriate to start clustering database servers?