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 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
