What about implementing a bitmap index? Any use cases? - Mailing list pgsql-performance

From Stefan Keller
Subject What about implementing a bitmap index? Any use cases?
Date
Msg-id CAFcOn280Ed0Zk=O6g7OhbZZ-g-mQWKj4p+B_EA6sTv21mXnraw@mail.gmail.com
Whole thread Raw
Responses Re: What about implementing a bitmap index? Any use cases?  (Peter Geoghegan <peter@2ndquadrant.com>)
List 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 by date:

Previous
From: Stefan Keller
Date:
Subject: Re: Hash index use presently(?) discouraged since 2005: revive or bury it?
Next
From: Peter Geoghegan
Date:
Subject: Re: What about implementing a bitmap index? Any use cases?