Chris,

> How "fixed" is the btree index growth issue in 7.4?  Does it mean no more
> reindexing ever?  Or does it mean reindexing once a month instead of once a
> week?

The Free Space Map has been extended to cover indexes.  So this means that 
with proper FSM tuning, one may be able to eliminate or tremendously postpone 
REINDEX.

Without proper FSM tuning, of course, you're no better off than 7.3.


-- 
-Josh Berkus
 Aglio Database Solutions
 San Francisco


---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Reply via email to