Date: Fri, 23 Sep 2005 13:03:05 -0400
From: Alvaro Herrera <alvherre@alvh.no-ip.org>
To: Stef <svb@ucs.co.za>
Cc: Bruno Wolff III <bruno@wolff.to>,
	Markus Benne <markus@m-bass.com>, pgsql-performance@postgresql.org
Subject: Re: VACUUM FULL vs CLUSTER
Message-ID: <20050923170304.GC7575@surnet.cl>
Mail-Followup-To: Stef <svb@ucs.co.za>,
	Bruno Wolff III <bruno@wolff.to>, Markus Benne <markus@m-bass.com>,
	pgsql-performance@postgresql.org
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=us-ascii
Content-Disposition: inline
In-Reply-To: <20050923181644.161bf160@svb.ucs.co.za>
User-Agent: Mutt/1.5.10i

On Fri, Sep 23, 2005 at 06:16:44PM +0200, Stef wrote:
> 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?

The worst problems were solved in 7.4.  There are problems in certain
limited circumstances even with current releases.

-- 
Alvaro Herrera                  http://www.amazon.com/gp/registry/DXLWNGRJD34
"The ability to monopolize a planet is insignificant
next to the power of the source"