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 291A89FA621 for ; Wed, 30 Aug 2006 07:21:53 -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 13292-05-5 for ; Wed, 30 Aug 2006 07:21:44 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 64F119FB314 for ; Wed, 30 Aug 2006 07:20:06 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from smtp01.isdsl.net (smtp01.isdsl.net [196.26.208.190]) by svr4.postgresql.org (Postfix) with ESMTP id 32DD95AF043 for ; Wed, 30 Aug 2006 10:20:05 +0000 (GMT) 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 6AE162FDD2 for ; Wed, 30 Aug 2006 12:20:01 +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 12:24:21 +0200 Message-ID: <44F56649.9050604@studentvillage.co.za> Date: Wed, 30 Aug 2006 12:19:53 +0200 From: Willo van der Merwe User-Agent: Thunderbird 1.5.0.5 (Windows/20060719) MIME-Version: 1.0 To: Merlin Moncure Cc: pgsql-performance@postgresql.org Subject: Re: PostgreSQL performance issues References: <44F446B2.2090900@studentvillage.co.za> In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-OriginalArrivalTime: 30 Aug 2006 10:24:21.0359 (UTC) FILETIME=[752CBFF0:01C6CC1E] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.407 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200608/465 X-Sequence-Number: 20650 Merlin Moncure wrote: > On 8/29/06, Willo van der Merwe wrote: > >> and it has 743321 rows and a explain analyze select count(*) from >> property_values; >> > > you have a number of options: All good ideas and I'll be sure to implement them later. > I am curious why you need to query the count of records in the log > table to six digits of precision. I'm not with you you here. I'm drawing statistic for the my users on a per user basis in real-time, so there are a couple of where clauses attached. > > merlin > Hi Merlin, This was just an example. All queries have slowed down. Could it be that I've reached some cut-off and now my disk is thrashing? 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