Jim C. Nasby wrote:
> Having indexes that people shouldn't be using does add confusion for
> users, and presents the opportunity for foot-shooting.
Emitting a warning/notice on hash-index creation is something I've
suggested in the past -- that would be fine with me.
> Even if there is some kind of advantage (would they possibly speed up
> hash joins?)
No, hash joins and hash indexes are unrelated.
-Neil