X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 844D89DC99F for ; Mon, 13 Feb 2006 11:09:47 -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 34091-06 for ; Mon, 13 Feb 2006 11:09:51 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by postgresql.org (Postfix) with ESMTP id 5D2759DCC25 for ; Mon, 13 Feb 2006 11:09:45 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.13.1/8.13.1) with ESMTP id k1DF9g8i058901 for ; Mon, 13 Feb 2006 15:09:42 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.13.1/8.13.1/Submit) id k1DF3xY8058200 for pgsql-admin@postgresql.org; Mon, 13 Feb 2006 11:03:59 -0400 (AST) (envelope-from news) From: Chris Browne X-Newsgroups: pgsql.admin Subject: Re: How to VACUUM this table? "998994633 estimated total rows" Date: Mon, 13 Feb 2006 09:59:33 -0500 Organization: cbbrowne Computing Inc Lines: 15 Message-ID: <60k6bzcnje.fsf@dba2.int.libertyrms.com> References: <43ED56D3.7040404@mediaroot.de> <60ek29e3tw.fsf@dba2.int.libertyrms.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Complaints-To: usenet@news.hub.org User-Agent: Gnus/5.1007 (Gnus v5.10.7) XEmacs/21.4.18 (linux) Cancel-Lock: sha1:x1e3Y/WKKgwbE3yvkizKtKTCM9E= To: pgsql-admin@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=-1.279 required=5 tests=[ALL_TRUSTED=-1.44, AWL=0.161] X-Spam-Score: -1.279 X-Spam-Level: X-Archive-Number: 200602/160 X-Sequence-Number: 20581 gbarosio@gmail.com (Guido Barosio) writes: > quote: " If you are quite sure it has few if any dead tuples, it might be > something to try to avoid VACUUMing except as needed to evade the 2^31 > transaction limit..." > You may use the pg_stattuple software, included in the /contrib . This will show you the current scenery, and whether you shall clean or not dead tuples. The trouble with pg_stattuple() is that running it is virtually as expensive as running the vacuum. For a bit table, you pay all the I/O cost, and any costs of the super-long-running-transaction and don't even get any cleanup for that cost. -- let name="cbbrowne" and tld="cbbrowne.com" in name ^ "@" ^ tld;; http://cbbrowne.com/info/lsf.html Philosophy is a game with objectives and no rules. Mathematics is a game with rules and no objectives.