Skip site navigation (1) Skip section navigation (2)

Re: index bloat in 8.4-dev

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: (view raw, whole thread or download thread mbox)
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

I did see some kind of problem here in a more complex case, but I think
I'll have to narrow it down again.

		Jeff Davis

In response to

pgsql-bugs by date

Next:From: Andrej PodzimekDate: 2008-10-08 14:48:09
Subject: BUG #4455: Valid SSL certificate reported as expired
Previous:From: Rainer BauerDate: 2008-10-07 15:37:06
Subject: BUG #4454: LC_MESSAGES and LC_NUMERIC not working on Windows

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group