X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id B4637D9306 for ; Fri, 23 Sep 2005 15:04:15 -0300 (ADT) 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 39360-01 for ; Fri, 23 Sep 2005 18:04:07 +0000 (GMT) Received: from floppy.pyrenet.fr (news.pyrenet.fr [194.116.145.2]) by svr1.postgresql.org (Postfix) with ESMTP id 2DD91D920C for ; Fri, 23 Sep 2005 15:04:05 -0300 (ADT) Received: by floppy.pyrenet.fr (Postfix, from userid 106) id F214031F51; Fri, 23 Sep 2005 20:04:04 +0200 (MET DST) From: Chris Browne X-Newsgroups: pgsql.performance Subject: Re: VACUUM FULL vs CLUSTER Date: Fri, 23 Sep 2005 13:48:32 -0400 Organization: cbbrowne Computing Inc Lines: 17 Message-ID: <60ll1noetr.fsf@dba2.int.libertyrms.com> References: <5.2.0.9.1.20050920144041.0287c300@pop.puc.cl> <1127242399.26562.15.camel@host-140.engineering.n-able.com> <20050923142027.GC2298@wolff.to> <20050923181644.161bf160@svb.ucs.co.za> Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 X-Complaints-To: usenet@news.hub.org User-Agent: Gnus/5.1007 (Gnus v5.10.7) XEmacs/21.4.17 (Jumbo Shrimp, linux) Cancel-Lock: sha1:sjFDQAZ3l/ybDeeqLPwtzqIzx9g= To: pgsql-performance@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.094 required=5 tests=[AWL=0.094] X-Spam-Level: X-Archive-Number: 200509/312 X-Sequence-Number: 14620 svb@ucs.co.za (Stef) writes: > Bruno Wolff III mentioned : > => If you have a proper FSM setting you shouldn't need to do vacuum fulls > => (unless you have an older version of postgres where index bloat might > => be an issue). > > What version of postgres was the last version that had > the index bloat problem? I believe that was fixed in 7.3; it was certainly resolved by 7.4... -- (format nil "~S@~S" "cbbrowne" "cbbrowne.com") http://www.ntlug.org/~cbbrowne/spiritual.html MICROS~1 has brought the microcomputer OS to the point where it is more bloated than even OSes from what was previously larger classes of machines altogether. This is perhaps Bill's single greatest accomplishment.