Re: Performant queries on table with many boolean columns

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Performant queries on table with many boolean columns
Дата
Msg-id CAKFQuwY3z7oGwriDie4guGPudy_k8S4wWJKrTRy7zPKjTUm=wQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Performant queries on table with many boolean columns  (Teodor Sigaev <teodor@sigaev.ru>)
Ответы Re: Performant queries on table with many boolean columns  (Teodor Sigaev <teodor@sigaev.ru>)
Список pgsql-performance
Дерево обсуждения
On Wed, Apr 20, 2016 at 11:54 AM, Teodor Sigaev <teodor@sigaev.ru> wrote:

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

​Curious, it doesn't look like it will work with booleans out of the box.


David J.
​
 

В списке pgsql-performance по дате отправления:

Предыдущее
От: Rick Otten
Дата:
Сообщение: Re: Performant queries on table with many boolean columns
Следующее
От: "Sven Kerkling"
Дата:
Сообщение: Performance problems with postgres and null Values?