Re: Performant queries on table with many boolean columns

From: Teodor Sigaev <teodor(at)sigaev(dot)ru>
To: Rob Imig <rimig88(at)gmail(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Performant queries on table with many boolean columns
Date: 2016-04-20 18:54:54
Message-ID: 5717D07E.3070802@sigaev.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)sigaev(dot)ru
WWW: http://www.sigaev.ru/

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Rick Otten 2016-04-20 21:07:27 Re: Performant queries on table with many boolean columns
Previous Message Rob Imig 2016-04-20 18:41:54 Performant queries on table with many boolean columns