Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 196D89FB6C0 for ; Fri, 17 Aug 2007 22:14:06 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 46244-10 for ; Fri, 17 Aug 2007 22:13:58 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from rv-out-0910.google.com (rv-out-0910.google.com [209.85.198.186]) by postgresql.org (Postfix) with ESMTP id 37E309FA249 for ; Fri, 17 Aug 2007 22:14:03 -0300 (ADT) Received: by rv-out-0910.google.com with SMTP id l15so556140rvb for ; Fri, 17 Aug 2007 18:14:01 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=Ns3k2AV7B1iA815trVWownlcHXqmTcTdP5ywWcbM/W1OOjSElbalMSs4m2YW4/q4dhDeOU8TkEn+lS8hO6JKXrqr7z8hOzFE9n693fI3b4KXvh3Dw/50Q7oPyGadqwiMOMV9OtixEQFpY2ce5b1tDcPERAIsQFpq7MT4QE0EgvQ= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=mgpMLH8zhS0n9vxzcx2/YaX1Ygs6FdW/3PsKCFtveNyup/egZvk14HQ1EtyQf5b1wWDqmAeXnoLCxVmNL+/sZ0dUU8jT1TIpoYK7iz0IqZOQnJYnG2SYiM+wJBDLdRO7z+xV2rGEAkzhPCrG03yAOU/U+SldZfPrzUO4cHSmHbU= Received: by 10.141.15.19 with SMTP id s19mr1544052rvi.1187399641272; Fri, 17 Aug 2007 18:14:01 -0700 (PDT) Received: by 10.141.98.12 with HTTP; Fri, 17 Aug 2007 18:14:01 -0700 (PDT) Message-ID: Date: Fri, 17 Aug 2007 20:14:01 -0500 From: "Scott Marlowe" To: "Detlef Rudolph" Subject: Re: select count(*) performance Cc: pgsql-performance@postgresql.org In-Reply-To: <5i64cvF3mnmcsU1@mid.individual.net> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <1186578085.034463.116030@q75g2000hsh.googlegroups.com> <5i64cvF3mnmcsU1@mid.individual.net> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/186 X-Sequence-Number: 26316 On 8/11/07, Detlef Rudolph wrote: > Hello Group, > > I've tried the VACUUM ANALYSE, that doesn't help > much, but VACUUM FULL improves Performance down > from about 40 secs to 8. If vacuum full fixes a performance problem, then you have a regular vacuum problem of some sort. Make sure regular vacuum runs often enough and make sure your fsm settings are high enough to allow it to reclaim all deleted tuples when it does run.