| 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-07 08:04:47 |
| Message-ID: | 48EB181F.10703@enterprisedb.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeff Davis | 2008-10-07 15:14:21 | Re: index bloat in 8.4-dev |
| Previous Message | Jeff Davis | 2008-10-06 20:36:33 | Re: index bloat in 8.4-dev |