Re: btree index growth - Mailing list pgsql-hackers

From Josh Berkus
Subject Re: btree index growth
Date
Msg-id 200307031939.58656.josh@agliodbs.com
Whole thread Raw
In response to btree index growth  ("Christopher Kings-Lynne" <chriskl@familyhealth.com.au>)
List pgsql-hackers
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 BerkusAglio Database SolutionsSan Francisco



pgsql-hackers by date:

Previous
From: The Hermit Hacker
Date:
Subject: Re: How to submit Tsearch V2 ?
Next
From: Tom Lane
Date:
Subject: Error messages --- now that we've got it, do you like it?