X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id B67693A584A for ; Tue, 25 Jan 2005 18:48:14 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 03310-06 for ; Tue, 25 Jan 2005 18:48:09 +0000 (GMT) Received: from web30309.mail.mud.yahoo.com (web30309.mail.mud.yahoo.com [68.142.200.102]) by svr1.postgresql.org (Postfix) with SMTP id ABA743A582F for ; Tue, 25 Jan 2005 18:48:08 +0000 (GMT) Received: (qmail 3868 invoked by uid 60001); 25 Jan 2005 18:48:08 -0000 Comment: DomainKeys? See http://antispam.yahoo.com/domainkeys DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; b=A5eSyebUC3FDRiqBDzjoSlkAVcNYNRtA28O26aVf3yYeEB0SzNbB9DowM5J31hTzU66dhW4AUrQYgx7T/bjoUjlswGIAUaYcNgaJmlWPS8m9e9TCiOfAiKFXuLiNt0IgwKRUkvQH1GstKq3Lrv1ciCB/s4ghaSj2nKihYJvXk6U= ; Message-ID: <20050125184808.3866.qmail@web30309.mail.mud.yahoo.com> Received: from [63.78.249.254] by web30309.mail.mud.yahoo.com via HTTP; Tue, 25 Jan 2005 10:48:08 PST Date: Tue, 25 Jan 2005 10:48:08 -0800 (PST) From: Litao Wu Subject: Re: reltuples after vacuum and analyze To: Tom Lane Cc: pgsql-performance@postgresql.org In-Reply-To: <5692.1106678631@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.87 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, FORGED_YAHOO_RCVD X-Spam-Level: * X-Archive-Number: 200501/483 X-Sequence-Number: 10173 Believe or not. The above command is my screen snapshot. I believe it is most possibably a PG bug! --- Tom Lane wrote: > Litao Wu writes: > > reasonable size. But I do not understand > > why "analyze" bloats the table size so > > big?? > > ANALYZE won't bloat anything. I suppose you have > other processes > inserting or updating data in the table meanwhile. > > regards, tom lane > __________________________________ Do you Yahoo!? All your favorites on one personal page – Try My Yahoo! http://my.yahoo.com