"Rajesh Kumar Mallah" <mallah.rajesh@xxxxxxxxx> writes: > Suppose an index get corrupted. And you need create a new index > with exact specs and then drop the old index. Is it better to > have a performing corrupted index or not have it at all and temporarily > suffer some performance degradation ? The case that was being discussed just a day or two ago was where you wanted to do the equivalent of REINDEX because of index bloat, not any functional "corruption". In that case it's perfectly clear that temporarily not having the index isn't acceptable ... especially if it's enforcing a unique constraint. regards, tom lane
