Skip site navigation (1) Skip section navigation (2)

Re: index bloat in 8.4-dev

From: Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
To: Jeff Davis <pgsql(at)j-davis(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: index bloat in 8.4-dev
Date: 2008-10-06 08:10:56
Message-ID: 48E9C810.5000002@enterprisedb.com (view raw or flat)
Thread:
Lists: 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

In response to

Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2008-10-06 12:06:41
Subject: Re: RES: BUG #4450: Postgres do not ask for passord
Previous:From: Magnus HaganderDate: 2008-10-06 08:03:23
Subject: Re: BUG #4451: initcap() function capitalizes incorrectly

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group