On 21 September 2016 at 13:29, Robert Haas <robertmh...@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... -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers