Re: Bloom index
Robert Haas <robertmhaas@gmail.com>
From: Robert Haas <robertmhaas@gmail.com>
To: Teodor Sigaev <teodor@sigaev.ru>
Cc: Pgsql Hackers <pgsql-hackers@postgresql.org>
Date: 2010-01-13T15:15:14Z
Lists: pgsql-hackers
2010/1/13 Teodor Sigaev <teodor@sigaev.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