Re: index growth problem - Mailing list pgsql-performance

From Jim C. Nasby
Subject Re: index growth problem
Date
Msg-id 20061018225156.GG56874@nasby.net
Whole thread Raw
In response to Re: index growth problem  (Graham Davis <gdavis@refractions.net>)
List pgsql-performance
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 recent releases, no. Remember that any index on a field that gets
update activity will naturally have some amount of empty space due to
page splits, but this is normal (and actually desireable). So you can't
just compare index size before and after a REINDEX and assume
something's wrong if REINDEX shrinks the index; that gain is artificial.

So long as you are vacuuming frequently enough and keep the free space
map large enough, there shouldn't be any need to REINDEX.
--
Jim Nasby                                            jim@nasby.net
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)

pgsql-performance by date:

Previous
From: Graham Davis
Date:
Subject: Re: index growth problem
Next
From: Tom Lane
Date:
Subject: Re: index growth problem