4 ms·
Curious how you'd do bitmap indexes at a user level in postgres? An extension like pg_roaringbitmap [1] or am I missing something native? [1] https://pgxn.org/
by code_biologist 5y ago
Curious how you'd do bitmap indexes at a user level in postgres? An extension like pg_roaringbitmap [1] or am I missing something native?
[1] https://pgxn.org/dist/pg_roaringbitmap/ https://pgxn.org/dist/pg_roaringbitmap/
- twoodfin 5y agoAFAICT bitmaps as a persistent index structure aren’t supported. They’re only used in-memory at query runtime for combining results from multiple index scans.
- hansvm 5y agoI've hacked together something nearly equivalent to roaring bitmaps with varbits and a bit of extra metadata. Caveat emptor, but it was good enough for the problem at hand.