X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 9E32C9DCB7A for ; Mon, 27 Mar 2006 15:21:23 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 54077-09 for ; Mon, 27 Mar 2006 15:21:23 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from outbound.mailhop.org (outbound.mailhop.org [63.208.196.171]) by postgresql.org (Postfix) with ESMTP id 6812C9DCAA1 for ; Mon, 27 Mar 2006 15:21:21 -0400 (AST) Received: from ool-4350c8e6.dyn.optonline.net ([67.80.200.230] helo=[192.168.0.96]) by outbound.mailhop.org with esmtpa (Exim 4.51) id 1FNxHB-000CMR-9z; Mon, 27 Mar 2006 14:21:17 -0500 X-Mail-Handler: MailHop Outbound by DynDNS X-Originating-IP: 67.80.200.230 X-Report-Abuse-To: abuse@dyndns.com (see http://www.mailhop.org/outbound/abuse.html for abuse reporting information) X-MHO-User: zeut Message-ID: <44283B42.7060803@zeut.net> Date: Mon, 27 Mar 2006 14:21:38 -0500 From: "Matthew T. O'Connor" User-Agent: Thunderbird 1.4 (Windows/20050908) MIME-Version: 1.0 To: =?ISO-8859-1?Q?G=E1briel_=C1kos?= CC: pgsql-performance@postgresql.org Subject: Re: count(*) performance References: <44282D45.7020008@i-logic.hu> In-Reply-To: <44282D45.7020008@i-logic.hu> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.128 required=5 tests=[AWL=0.128] X-Spam-Score: 0.128 X-Spam-Level: X-Archive-Number: 200603/529 X-Sequence-Number: 17966 Gábriel Ákos wrote: > Luke Lonergan wrote: >> Gabriel, >> >> On 3/27/06 10:05 AM, "Gábriel Ákos" wrote: >> >>> That gave me an idea. I thought that autovacuum is doing it right, but I >>> issued a vacuum full analyze verbose , and it worked all the day. >>> After that I've tweaked memory settings a bit too (more fsm_pages) >> >> Oops! I replied to your disk speed before I saw this. >> >> The only thing is - you probably don't want to do a "vacuum full", but >> rather a simple "vacuum" should be enough. > > I thought that too. Autovacuum is running on our system but it didn't do > the trick. Anyway the issue is solved, thank you all for helping. :) Yeah, it would be nice of autovacuum had some way of raising a flag to the admin that given current settings (thresholds, FSM etc...), it's not keeping up with the activity. I don't know how to do this, but I hope someone else has some good ideas. Matt