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
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org
