Re: Performant queries on table with many boolean columns - Mailing list pgsql-performance

From Teodor Sigaev
Subject Re: Performant queries on table with many boolean columns
Date
Msg-id 5717D07E.3070802@sigaev.ru
Whole thread Raw
In response to Performant queries on table with many boolean columns  (Rob Imig <rimig88@gmail.com>)
Responses Re: Performant queries on table with many boolean columns  (Rick Otten <rottenwindfish@gmail.com>)
Re: Performant queries on table with many boolean columns  ("David G. Johnston" <david.g.johnston@gmail.com>)
Re: Performant queries on table with many boolean columns  (Jeff Janes <jeff.janes@gmail.com>)
List pgsql-performance
>
> 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: teodor@sigaev.ru
                                       WWW: http://www.sigaev.ru/


pgsql-performance by date:

Previous
From: Rob Imig
Date:
Subject: Performant queries on table with many boolean columns
Next
From: Rick Otten
Date:
Subject: Re: Performant queries on table with many boolean columns