Re: Bloom index - Mailing list pgsql-hackers

From Oleg Bartunov
Subject Re: Bloom index
Date
Msg-id Pine.LNX.4.64.1001132335100.17883@sn.sai.msu.ru
Whole thread Raw
In response to Re: Bloom index  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
On Wed, 13 Jan 2010, Robert Haas wrote:

> 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).

Yes, one of the goal of our announcement is to let potential users to know
what we have done and what benefits it (index) provides.

In other words, sponsor(s), you are welcome !
    Regards,        Oleg
_____________________________________________________________
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(495)939-16-83, +007(495)939-23-83

pgsql-hackers by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: plpython3
Next
From: Chris Browne
Date:
Subject: Re: RFC: PostgreSQL Add-On Network