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

Jeff Davis wrote:
> I see this problem on 8.3.3 now, too. Originally, I suppose my test was
> not long enough, but now I see the problem after about 10 minutes of
> running.

I ran the script for about 30 minutes on CVS HEAD, and the index didn't
grow at all after the first three iterations. Are you sure you didn't
have a long-running transaction open that prevented vacuum from working?
Did the heap bloat as well, or just the index?

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