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