Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
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 !

Oleg Bartunov, Research Scientist, Head of AstroNet (,
Sternberg Astronomical Institute, Moscow University, Russia
Internet: oleg(at)sai(dot)msu(dot)su,
phone: +007(495)939-16-83, +007(495)939-23-83

In response to

pgsql-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group