Roaringbitmap is an efficient Bitmap compression algorithm. Bitmap bit calculation is very suitable for big data cardinality calculation, and is often used in calculation of weight removal, label filtering, time series, etc. The GPDB-RoaringBitmap plug-in integrates the RoaringBitmap function into the Greenplum database, providing the roaringBitmap as a data type to support native database functions, operators, aggregation, and other functions.

Gpdb-roaringbitmap added second-order aggregation in v0.2.65.1 to improve performance by 20 times in some specific scenarios.

In the new version of the plugin, v0.2.66, the aggregation result error bug is fixed, and all users of the previous version are advised to update.

  • This version only supports GPDB6.
  • Update Croaring version to 0.2.66 to address memory leaks in certain situations.
  • Fixed rb_AND_AGg, rb_AND_CARDINality_agg result error when the number of bitmaps is very small.
  • We recommend that all users of historical versions update.

Upgrade method:

make
make install
psql -c "alter extension roaringbitmap update;"
Copy the code

For more information about this project, please visit the project home page

For application examples of this project, please refer to Greenplum in TalkingData

For more technical know-how on Greenpum, please visit Greenplum’s Chinese community website.