Re: vacuumdb is failing with NUMBER OF INDEX TUPLES NOT - Mailing list pgsql-general

On Sat, May 08, 2004 at 12:31:28PM -0400, Tom Lane wrote:
> However, I haven't the foggiest idea what sort of corruption might
> allow the index to seem to work (and not, say, crash the reindex itself
> which is going to use that information...) yet allow problems to appear
> much later on.  Too bad the evidence is gone now.

Dunno if this is any help, but on a 7.2 system I saw a REINDEX which
was interrupted leave the index at least partially working.  We ended
up with an index which seemed fine, but which didn't contain certain
rows (so those rows were not visible when the SELECT criterion was
the indexed field).  This was extremely puzzling, but a DROP INDEX;
CREATE INDEX pair solved it.

A

--
Andrew Sullivan  | ajs@crankycanuck.ca
The plural of anecdote is not data.
        --Roger Brinner