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 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
