Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

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/



I'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.


AFAICT 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.




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: