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 -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs