On version 10 and 11 hash index was redesigned and now seems to be better
than btree.
Their speed, size and memory consuption are better, so ...
Why is not possible to have all PK and FK just using hash indices ? The only
thing I need on a PK and FK is search and join, so hash index responds very
well.
I know a hash doesn´t accept unique index, so I cannot create a primary key
on it.
But I think it would be great, isn´t it ?
There is something wrong with my thought ?
If not, there is a way to have PK/FH structure using Hash index ?
--
Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html