Re: index bloat in 8.4-dev

Поиск
Список
Период
Сортировка
От Heikki Linnakangas
Тема Re: index bloat in 8.4-dev
Дата
Msg-id 48E9C810.5000002@enterprisedb.com
обсуждение исходный текст
Ответ на index bloat in 8.4-dev  (Jeff Davis <pgsql@j-davis.com>)
Ответы Re: index bloat in 8.4-dev
Список pgsql-bugs
Jeff Davis wrote:
> I am seeing index bloat in the current head when the indexed values are
> constantly increasing, and the lower values are being constantly
> deleted.
>
> ...
> It's possible that this has something to do with the new FSM.

Yep, it clearly has. Looks like I forgot about the index FSMs when I
added the FSM vacuum code. Index FSMs need to be vacuumed just like the
heap FSM. Fixed, thanks for the report.

--
   Heikki Linnakangas
   EnterpriseDB   http://www.enterprisedb.com

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