| From: | Jeff Davis <pgsql(at)j-davis(dot)com> |
|---|---|
| To: | Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com> |
| Cc: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: index bloat in 8.4-dev |
| Date: | 2008-10-07 19:20:45 |
| Message-ID: | 1223407245.9936.8.camel@dell.linuxdev.us.dell.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
On Tue, 2008-10-07 at 08:14 -0700, Jeff Davis wrote:
> In the VACUUM VERBOSE output I included, you can see that the heap is
> only 785 pages (after 200M rows went through that table), and it
> maintains that consistently. That means to me that the VACUUMs are
> running and properly freeing the space in the heap. And the output seems
> to indicate that it thinks it can re-use those index pages, it just
> doesn't.
I think something may have been flawed in my simpler tests, so ignore
this.
I did see some kind of problem here in a more complex case, but I think
I'll have to narrow it down again.
Regards,
Jeff Davis
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrej Podzimek | 2008-10-08 14:48:09 | BUG #4455: Valid SSL certificate reported as expired |
| Previous Message | Rainer Bauer | 2008-10-07 15:37:06 | BUG #4454: LC_MESSAGES and LC_NUMERIC not working on Windows |