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 9301ED923D
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Fri, 23 Sep 2005 13:16:54 -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 11095-07
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Fri, 23 Sep 2005 16:16:51 +0000 (GMT)
Received: from ucsns.ucs.co.za (ucsns.ucs.co.za [196.23.43.2])
	by svr1.postgresql.org (Postfix) with ESMTP id 24D62D8D77
	for <pgsql-performance@postgresql.org>;
	Fri, 23 Sep 2005 13:16:48 -0300 (ADT)
Received: from ucspost.ucs.co.za (mailgw1.ucs.co.za [196.23.43.253])
	by ucsns.ucs.co.za (Postfix) with ESMTP id 4A6552BD50;
	Fri, 23 Sep 2005 18:16:45 +0200 (SAST)
Received: from jhb.ucs.co.za (jhb.ucs.co.za [172.31.1.3])
	by ucspost.ucs.co.za (Postfix) with ESMTP id 570D3D9DAA;
	Fri, 23 Sep 2005 18:16:45 +0200 (SAST)
Received: from svb.ucs.co.za (svb.ucs.co.za [172.31.1.148])
	by jhb.ucs.co.za (Postfix) with ESMTP id 0AAB1977C4;
	Fri, 23 Sep 2005 18:16:45 +0200 (SAST)
Date: Fri, 23 Sep 2005 18:16:44 +0200
From: Stef <svb@ucs.co.za>
To: Bruno Wolff III <bruno@wolff.to>
Cc: Markus Benne <markus@m-bass.com>,
	pgsql-performance@postgresql.org
Subject: Re: VACUUM FULL vs CLUSTER
Message-ID: <20050923181644.161bf160@svb.ucs.co.za>
In-Reply-To: <20050923142027.GC2298@wolff.to>
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>
X-Mailer: Sylpheed-Claws 1.9.6cvs1 (GTK+ 2.6.9; i486-pc-linux-gnu)
User-Agent: sillypheed-claws (anti-aliased)
X-Face: +lU/o'$=Zv9%Xjo]Kq[_{n&Kb`f{YE<S+T;
	pGztI>WH4&Y#M]'6BkD?VoWe#*@S\MWyD'I>s:0v4{#\[J]l*?]t2uaO(j$d*77Ca-UHo.tkl2)0$B3Jxww\o:xor]<:*Yfx9Vceh)9I/'2g\RKhGTxIIsR^ke^`LVeZ9ksb*:$kQeR@
X-Operating-System: sid
X-X-X: _-^-_
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.16 required=5 tests=[AWL=0.160]
X-Spam-Level: 
X-Archive-Number: 200509/303
X-Sequence-Number: 14611

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?