PostgreSQL's Hash Indexes Are Now Cool
Wasn't sure what a hash index was vs. btreeShort version - hash indexes are faster in PG11, but they only apply to "where = foobar" queries, giving a 0(1) time. Btree indexes have O(logn)But hash indexes can't be applied to range clauses, like "where SO post:https://stackoverflow.com/a/398921