| From: | Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> |
|---|---|
| To: | Stef <svb(at)ucs(dot)co(dot)za> |
| Cc: | Bruno Wolff III <bruno(at)wolff(dot)to>, Markus Benne <markus(at)m-bass(dot)com>, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: VACUUM FULL vs CLUSTER |
| Date: | 2005-09-23 17:03:05 |
| Message-ID: | 20050923170304.GC7575@surnet.cl |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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"
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gurpreet Aulakh | 2005-09-23 17:15:36 | Re: Query slower on 8.0.3 (Windows) vs 7.3 (cygwin) |
| Previous Message | Bruno Wolff III | 2005-09-23 16:59:52 | Re: VACUUM FULL vs CLUSTER |