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 355769DC870 for ; Tue, 17 Jan 2006 10:37:49 -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 39317-03 for ; Tue, 17 Jan 2006 10:37:52 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from floppy.pyrenet.fr (floppy.pyrenet.fr [194.116.145.2]) by postgresql.org (Postfix) with ESMTP id 425969DC81E for ; Tue, 17 Jan 2006 10:37:46 -0400 (AST) Received: by floppy.pyrenet.fr (Postfix, from userid 106) id 119B430F0A; Tue, 17 Jan 2006 15:37:50 +0100 (MET) From: Christopher Browne X-Newsgroups: pgsql.performance Subject: Re: Autovacuum / full vacuum Date: Tue, 17 Jan 2006 09:04:06 -0500 Organization: cbbrowne Computing Inc Lines: 18 Message-ID: References: <43CCC711.504@familyhealth.com.au> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Complaints-To: usenet@news.hub.org X-message-flag: Outlook is rather hackable, isn't it? X-Home-Page: http://www.cbbrowne.com/info/ X-Affero: http://svcs.affero.net/rm.php?r=cbbrowne User-Agent: Gnus/5.1006 (Gnus v5.10.6) XEmacs/21.4 (Jumbo Shrimp, berkeley-unix) Cancel-Lock: sha1:5GFLER1Wib5HwUcSX7No6LgyFx4= To: pgsql-performance@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.262 required=5 tests=[AWL=0.262] X-Spam-Score: 0.262 X-Spam-Level: X-Archive-Number: 200601/234 X-Sequence-Number: 16712 > did you read my post? In the first part I explained why I don't want > to increase the FSM that much. No, you didn't. You explained *that* you thought you didn't want to increase the FSM. You didn't explain why. FSM expansion comes fairly cheap, and tends to be an effective way of eliminating the need for VACUUM FULL. That is generally considered to be a good tradeoff. In future versions, there is likely to be more of this sort of thing; for instance, on the ToDo list is a "Vacuum Space Map" that would collect page IDs that need vacuuming so that PostgreSQL could do "quicker" vacuums... -- output = reverse("moc.liamg" "@" "enworbbc") http://cbbrowne.com/info/internet.html Given recent events in Florida, the tourism board in Texas has developed a new advertising campaign based on the slogan "Ya'll come to Texas, where we ain't shot a tourist in a car since November 1963."