Re: UNIQUE capability to hash indexes

On 2/4/16 1:12 PM, Tom Lane wrote:
> Shubham Barai <shubhambaraiss@gmail.com> writes:
>> I wanted to know if anyone is working on these projects from todo list.
>> 1.Add UNIQUE capability to hash indexes
>> 2.Allow multi-column hash indexes
>
> Not that I've heard of.  It's very hard to muster any enthusiasm for
> improving hash indexes unless their lack of WAL-logging is fixed first.

+1.

I currently steer customers away from hash indexes and have never used
them for any project myself.  They are simply not safe.

--
-David
david@pgmasters.net