Re: Save Hash Indexes

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема Re: Save Hash Indexes
Дата
Msg-id CAMkU=1z5rVnypCdaGieD988EoQzzmS0ga8HeA2RJbje=0a=NRA@mail.gmail.com
обсуждение исходный текст
Ответ на Save Hash Indexes  (Dimitri Fontaine <dimitri@2ndQuadrant.fr>)
Список 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 по дате отправления:

Предыдущее
От: Atri Sharma
Дата:
Сообщение: Re: Save Hash Indexes
Следующее
От: Daniel Farina
Дата:
Сообщение: Re: Save Hash Indexes