{"repo":"ChenHuajun/pg_roaringbitmap","free":true,"listed":false,"github":"https://github.com/ChenHuajun/pg_roaringbitmap","clone":"git clone https://github.com/ChenHuajun/pg_roaringbitmap.git","description":"RoaringBitmap extension for PostgreSQL","language":"C","stars":287,"topics":["roaring-bitmaps","pg-roaringbitmap","roaringbitmap-extension","postgresql","postgres","greenplum","gpdb"],"license":"Apache-2.0","category":"databases-storage","readme_excerpt":"pg roaringbitmap RoaringBitmap extension for PostgreSQL. This is originally based on https://github.com/zeromax007/gpdb-roaringbitmap. Introduction Roaring bitmaps are compressed bitmaps which tend to outperform conventional compressed bitmaps such as WAH, EWAH or Concise. In some instances, roaring bitmaps can be hundreds of times faster and they often offer significantly better compression. They can even be faster than uncompressed bitmaps. More information at https://github.com/RoaringBitmap/CRoaring. Build Requirements - PostgreSQL 10+ - Other Requirements from https://github.com/RoaringBitmap/CRoaring Note: The regression testing before the version release only covers PostgreSQL 13 and above. Build su - postgres make sudo make install psql -c \"create extension roaringbitmap\" Note: You can use make -f Makefile native instead of make to let the compiler use SIMD instructions if your CPU supports them. In some scenarios, it may double the performance. But if you use the pg roaringbitmap binary built with SIMD support on a machine without SIMD support, you could get a SIGILL crash. Test make installcheck Usage roaringbitmap about roaringbitmap data type Logically, you could think of the roaringbitmap data type as bit(4294967296) , and it should be noted that the integers added to bitmaps are considered to be unsigned. Within bitmaps, numbers are ordered according to uint32. We order the numbers like 0, 1, ..., 2147483647, -2147483648, -2147483647,..., -1. But we use bigint t","default_branch":null,"files":null,"tree":[],"storefront":"/r/ChenHuajun","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/ChenHuajun/pg_roaringbitmap/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}