> The obvious thing seems to make a table with ~100 columns, with 1 column
> for each boolean property. Though, what type of indexing strategy would
> one use on that table? Doesn't make sense to do BTREE. Is there a better
> way to structure it?
looks like a deal for contrib/bloom index in upcoming 9.6 release
Teodor Sigaev E-mail: