Re: UNIQUE capability to hash indexes - Mailing list pgsql-hackers

From David Steele
Subject Re: UNIQUE capability to hash indexes
Date
Msg-id 56B39648.10907@pgmasters.net
Whole thread Raw
In response to Re: UNIQUE capability to hash indexes  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: Victor Wagner
Date:
Subject: Re: [REVIEW] In-core regression tests for replication, cascading, archiving, PITR, etc.
Next
From: Michael Paquier
Date:
Subject: Re: [REVIEW] In-core regression tests for replication, cascading, archiving, PITR, etc.