openpolitics.com

Bloom Filters in Postgres 9.6

First, I need to load the extension:

$ create extension bloom; CREATE EXTENSION

 

Now, I can create index:

$ CREATE INDEX bloomidx ON test using bloom (i1,i2,i3,i4,i5,i6,i7,i8,i9);