I have a question about index growth.
The way I understand it, dead tuples in indexes were not reclaimed by
VACUUM commands in the past. However, I've read in a few forum posts
that this was changed somewhere between 7.4 and 8.0.
I'm having an issue where my GIST indexes are growing quite
On Wed, Oct 18, 2006 at 03:20:19PM -0700, Graham Davis wrote:
I have a question about index growth.
The way I understand it, dead tuples in indexes were not reclaimed by
VACUUM commands in the past. However, I've read in a few forum posts
that this was changed somewhere between 7.4 and
So I guess any changes that were made to make VACUUM and FSM include
indexes
does not remove the necessity to reindex (as long as we don't want index
sizes to bloat and grow larger than they need be).
Is that correct?
Graham.
Jim C. Nasby wrote:
On Wed, Oct 18, 2006 at 03:20:19PM -0700,
On Wed, Oct 18, 2006 at 03:39:56PM -0700, Graham Davis wrote:
So I guess any changes that were made to make VACUUM and FSM include
indexes
does not remove the necessity to reindex (as long as we don't want index
sizes to bloat and grow larger than they need be).
Is that correct?
Not in
Jim C. Nasby [EMAIL PROTECTED] writes:
On Wed, Oct 18, 2006 at 03:20:19PM -0700, Graham Davis wrote:
When I run the same command to find the size after the VACUUM, it hasn't
changed.
That's not really a useful test to see if VACUUM is working. VACUUM can
only trim space off the end of a