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@xxxxxxxxx EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
