Hash Index
IndexingAn index using a hash function for exact-match lookups only. Faster than B-tree for simple equality queries on high-cardinality columns. Does not support range queries. WAL-logged since PostgreSQL 10.
An index using a hash function for exact-match lookups only. Faster than B-tree for simple equality queries on high-cardinality columns. Does not support range queries. WAL-logged since PostgreSQL 10.