Re: Bloom index - Mailing list pgsql-hackers

From Robert Haas
Subject Re: Bloom index
Date
Msg-id 603c8f071001130715h6d69278ds2fbef49688a1fe88@mail.gmail.com
Whole thread Raw
In response to Bloom index  (Teodor Sigaev <teodor@sigaev.ru>)
Responses Re: Bloom index  (Teodor Sigaev <teodor@sigaev.ru>)
Re: Bloom index  (Oleg Bartunov <oleg@sai.msu.su>)
List pgsql-hackers
2010/1/13 Teodor Sigaev <teodor@sigaev.ru>:
> CREATE INDEX bloomidx ON tbloom(i1,i2,i3)
>       WITH (length=5, col1=2, col2=2, col3=4);
>
> Here, we create bloom index with signature length 80 bits and attributes
> i1, i2  mapped to 2 bits, attribute i3 - to 4 bits.

This is pretty darn slick.  I haven't looked at the code yet, but the
functionality sounds very cool, and I hope this is something we'll be
able to have as part of PG in the future (though more than likely not
for 8.5, I suspect).

...Robert


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: lock_timeout GUC patch
Next
From: Teodor Sigaev
Date:
Subject: Re: Bloom index