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 2787A9DCA15 for ; Mon, 27 Mar 2006 14:15:07 -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 28793-05 for ; Mon, 27 Mar 2006 14:15:06 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mail.mi8.com (d01gw02.mi8.com [63.240.6.46]) by postgresql.org (Postfix) with ESMTP id 9D0819DCA05 for ; Mon, 27 Mar 2006 14:15:01 -0400 (AST) Received: from 172.16.1.112 by mail.mi8.com with ESMTP (- Welcome to Mi8 Corporation www.Mi8.com (D2)); Mon, 27 Mar 2006 13:14:50 -0500 X-Server-Uuid: 7829E76E-BB9E-4995-8473-3C0929DF7DD1 Received: from MI8NYCMAIL06.Mi8.com ([172.16.1.160]) by D01SMTP02.Mi8.com with Microsoft SMTPSVC(6.0.3790.1830); Mon, 27 Mar 2006 13:14:50 -0500 Received: from 67.103.45.218 ([67.103.45.218]) by MI8NYCMAIL06.Mi8.com ( [172.16.1.219]) via Exchange Front-End Server mi8owa.mi8.com ( [172.16.1.118]) with Microsoft Exchange Server HTTP-DAV ; Mon, 27 Mar 2006 18:14:46 +0000 User-Agent: Microsoft-Entourage/11.2.3.060209 Date: Mon, 27 Mar 2006 10:14:45 -0800 Subject: Re: count(*) performance From: "Luke Lonergan" To: "G=?ISO-8859-1?B?4Q==?=briel =?ISO-8859-1?B?wQ==?=kos" , pgsql-performance@postgresql.org Message-ID: Thread-Topic: [PERFORM] count(*) performance Thread-Index: AcZRyTXakziMFhjkQk+VCH4tfohm4AAAR15a In-Reply-To: <4428296B.9040505@i-logic.hu> MIME-Version: 1.0 X-OriginalArrivalTime: 27 Mar 2006 18:14:50.0267 (UTC) FILETIME=[567946B0:01C651CA] X-WSS-ID: 6836F4102XS34959773-01-01 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=1.335 required=5 tests=[AWL=0.082, RCVD_NUMERIC_HELO=1.253] X-Spam-Score: 1.335 X-Spam-Level: * X-Archive-Number: 200603/525 X-Sequence-Number: 17962 Gabriel, On 3/27/06 10:05 AM, "G=E1briel =C1kos" 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. - Luke