What about implementing a bitmap index? Any use cases?

Поиск
Список
Период
Сортировка
От Stefan Keller
Тема What about implementing a bitmap index? Any use cases?
Дата
Msg-id CAFcOn280Ed0Zk=O6g7OhbZZ-g-mQWKj4p+B_EA6sTv21mXnraw@mail.gmail.com
обсуждение исходный текст
Ответы Re: What about implementing a bitmap index? Any use cases?
Список pgsql-performance
Hi,

I know there exist Bitmap Index Scan and Bitmap Heap Scan in Postgres.
What about implementing a bitmap index for explicit use (CREATE INDEX ...)?
Any use cases?
Bitmap indexes work best on values with low cardinality (categorical
data), would be efficient in space and ready for logic operations.

Stefan

P.S. Disclaimer (referring to my other thread about Hash): I'm not a
btree opposer :-> I'm just evaluating index alternatives.

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

Предыдущее
От: Stefan Keller
Дата:
Сообщение: Re: Hash index use presently(?) discouraged since 2005: revive or bury it?
Следующее
От: Peter Geoghegan
Дата:
Сообщение: Re: What about implementing a bitmap index? Any use cases?