On Mon, Apr 07, 2008 at 12:45:38PM -0400, Chris Browne wrote:
> versions of PostgreSQL. e.g. - with v7.2, there were patterns of
> updates that would leave portions of indexes not usable, but the issue
> was rectified in ~7.4, and people have not been observing problems
> relating to this former scenario.
There remain use patterns that will leave the indexes in pretty bad shape.
This is an inherent limiation with btrees, though -- if you just unbalanced
the tree with a large number of deletes, there's nothing you can do except
REINDEX.
A