Re: Save Hash Indexes - Mailing list pgsql-hackers

From Jeff Janes
Subject Re: Save Hash Indexes
Date
Msg-id CAMkU=1z5rVnypCdaGieD988EoQzzmS0ga8HeA2RJbje=0a=NRA@mail.gmail.com
Whole thread Raw
In response to Save Hash Indexes  (Dimitri Fontaine <dimitri@2ndQuadrant.fr>)
List pgsql-hackers
On Fri, Nov 1, 2013 at 6:31 AM, Dimitri Fontaine <dimitri@2ndquadrant.fr> wrote:
Hi,

Here's an idea: when a user ask for an Hash Index transparently build a
BTree index over an hash function instead.


Could something be added to the planner so that you can just build a btree index on a hash expression, and have the planner automatically realize it can used for an equality query because if a=b, then md5(a)=md5(b), at least for some data types?  A general ability to recognize things like that seems like it might have other uses as well.

Cheers,

Jeff

pgsql-hackers by date:

Previous
From: Atri Sharma
Date:
Subject: Re: Save Hash Indexes
Next
From: Daniel Farina
Date:
Subject: Re: Save Hash Indexes