Re: VACUUM FULL vs CLUSTER

From: Chris Browne <cbbrowne(at)acm(dot)org>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: VACUUM FULL vs CLUSTER
Date: 2005-09-23 17:48:32
Message-ID: 60ll1noetr.fsf@dba2.int.libertyrms.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

svb(at)ucs(dot)co(dot)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(at)~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.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2005-09-23 18:15:40 Re: [PERFORM] Releasing memory during External sorting?
Previous Message Mark Lewis 2005-09-23 17:43:02 Re: [PERFORM] Releasing memory during External sorting?