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?