Re: Let's drop two obsolete features which are bear-traps for novices - Mailing list pgsql-hackers

Andres Freund <andres@2ndquadrant.com> writes:
> A REINDEX is imo unlikely to be acceptable. It takes long (why would you
> bother on a small table?) and locks the relation/indexes.

I think the goalposts just took a vacation to Acapulco.

What exactly do you think is going to make a crashed unlogged index valid
again without a REINDEX?  Certainly the people who are currently using
hash indexes in the way Andrew describes are expecting to have to REINDEX
them after a crash.
        regards, tom lane