Re: Performant queries on table with many boolean columns

От: Teodor Sigaev
Тема: Re: Performant queries on table with many boolean columns
Дата: ,
Msg-id: 5717D07E.3070802@sigaev.ru
(см: обсуждение, исходный текст)
Ответ на: Performant queries on table with many boolean columns  (Rob Imig)
Ответы: Re: Performant queries on table with many boolean columns  (Rick Otten)
Re: Performant queries on table with many boolean columns  ("David G. Johnston")
Re: Performant queries on table with many boolean columns  (Jeff Janes)
Список: pgsql-performance

Скрыть дерево обсуждения

Performant queries on table with many boolean columns  (Rob Imig, )
 Re: Performant queries on table with many boolean columns  (Teodor Sigaev, )
  Re: Performant queries on table with many boolean columns  (Rick Otten, )
  Re: Performant queries on table with many boolean columns  ("David G. Johnston", )
   Re: Performant queries on table with many boolean columns  (Teodor Sigaev, )
    Re: Performant queries on table with many boolean columns  ("David G. Johnston", )
  Re: Performant queries on table with many boolean columns  (Jeff Janes, )
   Re: Performant queries on table with many boolean columns  (Rob Imig, )
    Re: Performant queries on table with many boolean columns  (Rob Imig, )
     Re: Performant queries on table with many boolean columns  (bricklen, )
      Re: Performant queries on table with many boolean columns  (bricklen, )
       Re: Performant queries on table with many boolean columns  (Merlin Moncure, )
        Re: Performant queries on table with many boolean columns  (Adam Brusselback, )
 Re: Performant queries on table with many boolean columns  (Jeff Janes, )

>
> 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: 
                                       WWW: http://www.sigaev.ru/



В списке pgsql-performance по дате сообщения:

От: "David G. Johnston"
Дата:
Сообщение: Re: Performant queries on table with many boolean columns
От: "Sven Kerkling"
Дата:
Сообщение: Performance problems with postgres and null Values?