gist index support

[DeoLeung]

hi,

I'm thinking to use roaringbitmap on table to indicate a row belongs to multiple "organizations", but having problem creating index on the column. Is there any plan to provides some gist operator so we can build a bitmap index on it?

https://www.postgresql.org/docs/14/indexes-types.html

thanks,

[ChenHuajun]

This may not be a common scenario.

roaringbitmap is suitable for storing large cardinality int sets, For large cardinality int sets, it may not be a good practice to create a gist index.

for small cardinality int sets, you can directly use the array type to store data, or create a function index on the roaringbitmap as an alternative.

for example: create index on tb1 using gist(rb_to_array(rb))

[DeoLeung]

thank you for the classification

we do use intarray now, and definitely function index will help when it fits