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).
In response to
pgsql-hackers by date
|Next:||From: Teodor Sigaev||Date: 2010-01-13 16:01:50|
|Subject: Re: Bloom index|
|Previous:||From: Tom Lane||Date: 2010-01-13 14:56:58|
|Subject: Re: lock_timeout GUC patch |