Bruce Momjian <bruce(at)momjian(dot)us> writes:
> On Fri, Jun 24, 2016 at 08:57:47PM +0000, Tom Lane wrote:
>> Fix building of large (bigger than shared_buffers) hash indexes.
> Do we have any way of helping people find out if they need to recreate
> their hash indexes?
I do not think that's much of an issue. The failure mode is hardly
non-obvious, because index searches would NEVER find any pre-existing
rows. (Well, there'd be circa one chance in 2^32 of an accidental
hashcode match, but that certainly won't be enough to mask the fact
that the index is broken.) Anyway, users of hash indexes are probably
accustomed to needing to reindex, on account of no WAL support :-(
regards, tom lane