Re: Index bloat of 4x

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Index bloat of 4x
Дата
Msg-id 19674.1169104105@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Index bloat of 4x  (Bill Moran <wmoran@collaborativefusion.com>)
Ответы Re: Index bloat of 4x  (Bill Moran <wmoran@collaborativefusion.com>)
Список pgsql-general
Bill Moran <wmoran@collaborativefusion.com> writes:
> It wasn't the fact that it bloated that surprised me.  It was the
> _magnitude_ of bloat that I wasn't expecting, as well as the fact that
> it was _all_ _index_ bloat.

Um, no, you had plenty of table *and* index bloat before.  The problem
here is that VACUUM FULL fixed all the table bloat whilst making the
index situation worse :-(

            regards, tom lane

В списке pgsql-general по дате отправления:

Предыдущее
От: Tino Wildenhain
Дата:
Сообщение: Re: datatype advice numeric vs. varchar
Следующее
От: "James Im"
Дата:
Сообщение: Re: Controlling memory of session