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 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
message can get through to the mailing list cleanly
