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

Re: Bloom index

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Teodor Sigaev <teodor(at)sigaev(dot)ru>
Cc: Pgsql Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Bloom index
Date: 2010-01-13 15:15:14
Message-ID: 603c8f071001130715h6d69278ds2fbef49688a1fe88@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-hackers
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).

...Robert

In response to

  • Bloom index at 2010-01-13 14:19:43 from Teodor Sigaev

Responses

pgsql-hackers by date

Next:From: Teodor SigaevDate: 2010-01-13 16:01:50
Subject: Re: Bloom index
Previous:From: Tom LaneDate: 2010-01-13 14:56:58
Subject: Re: lock_timeout GUC patch

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