From: Alvaro Herrera <alvherre@alvh.no-ip.org>
To: Stef <svb@ucs.co.za>
Cc: Bruno Wolff III <bruno@wolff.to>
Cc: Markus Benne <markus@m-bass.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: VACUUM FULL vs CLUSTER
Date: Fri, 23 Sep 2005 13:03:05 -0400
Message-ID: <20050923170304.GC7575@surnet.cl> (raw)
In-Reply-To: <20050923181644.161bf160@svb.ucs.co.za>
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>
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"
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: alvherre@alvh.no-ip.org, svb@ucs.co.za, bruno@wolff.to, markus@m-bass.com
Subject: Re: VACUUM FULL vs CLUSTER
In-Reply-To: <20050923170304.GC7575@surnet.cl>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox