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  (Jeff Davis <pgsql@j-davis.com>)
Список 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 по дате отправления:

Предыдущее
От: Magnus Hagander
Дата:
Сообщение: Re: BUG #4451: initcap() function capitalizes incorrectly
Следующее
От: Tom Lane
Дата:
Сообщение: Re: RES: BUG #4450: Postgres do not ask for passord