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?

Chris


Fri, 4 Jul 2003 10:26:48 +0800
"Christopher Kings-Lynne" <chriskl@familyhealth.com.au>
btree index growth
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


Thu, 3 Jul 2003 19:39:58 -0700
Josh Berkus <josh@agliodbs.com>
Re: btree index growth
"Christopher Kings-Lynne" <chriskl@familyhealth.com.au> writes:
> 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?

Try it and tell us ;-).  I think it will depend on your usage patterns
to some extent.

			regards, tom lane

Thu, 03 Jul 2003 23:08:18 -0400
Tom Lane <tgl@sss.pgh.pa.us>
Re: btree index growth 