Re: VACUUM FULL vs CLUSTER

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: VACUUM FULL vs CLUSTER
Дата
Msg-id 20050923170304.GC7575@surnet.cl
обсуждение исходный текст
Ответ на Re: VACUUM FULL vs CLUSTER  (Stef <svb@ucs.co.za>)
Список 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 по дате отправления:

Предыдущее
От: Bruno Wolff III
Дата:
Сообщение: Re: VACUUM FULL vs CLUSTER
Следующее
От: "Gurpreet Aulakh"
Дата:
Сообщение: Re: Query slower on 8.0.3 (Windows) vs 7.3 (cygwin)