Hash indexes

Hash indexes have been around for many years. The idea is to hash the input value and store it for later lookups. Having hash indexes actually makes sense. However, it is not advised to use them in PostgreSQL. The reason for that is that hashes are not very good at concurrency and have no support for the PostgreSQL transaction log. In short, you should not use them in real-world systems in the foreseeable future.