Re: btree index growth

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>, "Hackers" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: btree index growth
Date: 2003-07-04 02:39:58
Message-ID: 200307031939.58656.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 Berkus
Aglio Database Solutions
San Francisco

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2003-07-04 03:01:58 Error messages --- now that we've got it, do you like it?
Previous Message The Hermit Hacker 2003-07-04 02:35:09 Re: How to submit Tsearch V2 ?