Re: VACUUM FULL vs CLUSTER - Mailing list pgsql-performance

From Alvaro Herrera
Subject Re: VACUUM FULL vs CLUSTER
Date
Msg-id 20050923170304.GC7575@surnet.cl
Whole thread Raw
In response to Re: VACUUM FULL vs CLUSTER  (Stef <svb@ucs.co.za>)
List pgsql-performance
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"

pgsql-performance by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: VACUUM FULL vs CLUSTER
Next
From: "Gurpreet Aulakh"
Date:
Subject: Re: Query slower on 8.0.3 (Windows) vs 7.3 (cygwin)