Re: Hash Indexes - Mailing list pgsql-hackers

From Geoff Winkless
Subject Re: Hash Indexes
Date
Msg-id CAEzk6feXy6zcfnJcF3=mDVXqDB=qsnM1=WeXGCu1vLdhmN_cdw@mail.gmail.com
Whole thread Raw
In response to Re: Hash Indexes  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: Hash Indexes
Re: Hash Indexes
List pgsql-hackers
On 21 September 2016 at 13:29, Robert Haas <robertmhaas@gmail.com> wrote:
> I'd be curious what benefits people expect to get.

An edge case I came across the other day was a unique index on a large
string: postgresql popped up and told me that I couldn't insert a
value into the field because the BTREE-index-based constraint wouldn't
support the size of string, and that I should use a HASH index
instead. Which, of course, I can't, because it's fairly clearly
deprecated in the documentation...



pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Hash Indexes
Next
From: Tomas Vondra
Date:
Subject: Re: Better tracking of free space during SP-GiST index build