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

From Alvaro Herrera
Subject Re: UNIQUE capability to hash indexes
Date
Msg-id 20160204221809.GA242547@alvherre.pgsql
Whole thread Raw
In response to Re: UNIQUE capability to hash indexes  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: UNIQUE capability to hash indexes
List pgsql-hackers
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.

This is really strange though.  Surely adding WAL-logging is not an
enormous task anymore ... I mean, we're undertaking far larger efforts
now, the WAL logging code is simpler than before, and we even have a
tool (ok, gotta streamline that one a little bit) to verify that the
results are correct.

-- 
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services



pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: checkpoints after database start/immediate checkpoints
Next
From: Robert Haas
Date:
Subject: Re: postgres_fdw join pushdown (was Re: Custom/Foreign-Join-APIs)