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