"Jim C. Nasby" <decibel@decibel.org> writes:
> Well, in a hash-join right now you normally end up feeding at least one
> side of the join with a seqscan. Wouldn't it speed things up
> considerably if you could look up hashes in the hash index instead?
That's called a "nestloop with inner index scan", not a hash join.
regards, tom lane