Re: index bloat in 8.4-dev - Mailing list pgsql-bugs

From Heikki Linnakangas
Subject Re: index bloat in 8.4-dev
Date
Msg-id 48E9C810.5000002@enterprisedb.com
Whole thread Raw
In response to index bloat in 8.4-dev  (Jeff Davis <pgsql@j-davis.com>)
Responses Re: index bloat in 8.4-dev  (Jeff Davis <pgsql@j-davis.com>)
List 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 by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: BUG #4451: initcap() function capitalizes incorrectly
Next
From: Tom Lane
Date:
Subject: Re: RES: BUG #4450: Postgres do not ask for passord