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

From Jeff Davis
Subject Re: index bloat in 8.4-dev
Date
Msg-id 1223407245.9936.8.camel@dell.linuxdev.us.dell.com
Whole thread Raw
In response to Re: index bloat in 8.4-dev  (Jeff Davis <pgsql@j-davis.com>)
List 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

pgsql-bugs by date:

Previous
From: "Rainer Bauer"
Date:
Subject: BUG #4454: LC_MESSAGES and LC_NUMERIC not working on Windows
Next
From: "Andrej Podzimek"
Date:
Subject: BUG #4455: Valid SSL certificate reported as expired