Re: Bloom index

From: Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>
To: Robert Haas <robertmhaas(at)gmail(dot)com>
Cc: Teodor Sigaev <teodor(at)sigaev(dot)ru>, Pgsql Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Bloom index
Date: 2010-01-13 20:37:24
Message-ID: Pine.LNX.4.64.1001132335100.17883@sn.sai.msu.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wed, 13 Jan 2010, Robert Haas wrote:

> 2010/1/13 Teodor Sigaev <teodor(at)sigaev(dot)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(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/
phone: +007(495)939-16-83, +007(495)939-23-83

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Alex Hunsaker 2010-01-13 20:46:35 Re: [PATCH] remove redundant ownership checks
Previous Message Chris Browne 2010-01-13 20:18:22 Re: RFC: PostgreSQL Add-On Network