If Postgres 10 supports the hash index correctly, I would like to use the hash index to search for id (the hash index is smaller compared to btree and theoretically faster).
I have a table
create table t (id int);
create unique index on t using hash (id);
But I got the following:
ERROR: access method "hash" does not support unique indexes
Why does the hash index not allow a unique restriction? Are there any ways around this?
source
share