Re: UNIQUE capability to hash indexes

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
Cc: Shubham Barai <shubhambaraiss(at)gmail(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: UNIQUE capability to hash indexes
Date: 2016-02-04 22:34:45
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> writes:
> Tom Lane wrote:
>> 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.

ISTR that we discussed this previously and ran into some stumbling block
or other that made it less-than-trivial. Don't recall what though.

regards, tom lane

In response to


Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2016-02-04 22:39:27 Re: Development with Eclipse - Wrong error messages in IDE
Previous Message Tom Lane 2016-02-04 22:33:08 Re: count_nulls(VARIADIC "any")