pgbitmap 0.9.3

From: pgbitmap via PostgreSQL Announce <announce-noreply(at)postgresql(dot)org>
To: PostgreSQL Announce <pgsql-announce(at)lists(dot)postgresql(dot)org>
Subject: pgbitmap 0.9.3
Date: 2020-10-25 16:49:24
Message-ID: 160364456429.24751.492911943735257702@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-announce

Announcing the latest Beta release of pgbitmap, available from [pgxn](https://pgxn.org/dist/pgbitmap/)
and [github](https://github.com/marcmunro/pgbitmap).

pgbitmap provides a bitmap datatype for Postgres with a full set of functions, operators and aggregates.

This release fixes a number of issues with empty bitmaps and is considered a production release candidate. Any and all feedback is welcomed.

A bitmap is an array of bits, indexed by an integer. Bitmaps provide an efficient means to implement sets of integers. pgbitmap provides functions and operators for:

- creating new bitmaps;
- adding elements to bitmaps;
- removing elements from bitmaps;
- testing for inclusion of elements in bitmaps;
- finding the minimum and maximum bits in bitmaps;
- unioning bitmaps together (set union/logical or);
- intersecting bitmaps (set intersection/logical and);
- subtracting one bitmap from another;
- converting bitmaps to and from textual representations;
- converting bitmaps to and from arrays;
- aggregating bits and bitmaps into bitmaps.

It differs from the standard Postgres bitstring in that it isn't based around bit zero (bitmap(1000000) does not contain 1,000,000 zeroes followed by a 1) and it has more functionality.

It was developed primarily in order to efficiently manage sets of privileges for Virtual Private Database implementations.

Full documentation is available [here](https://marcmunro.github.io/pgbitmap/docs/html/index.html)

Browse pgsql-announce by date

  From Date Subject
Next Message Pgpool Global Development Group via PostgreSQL Announce 2020-10-28 17:28:29 Pgpool-II 4.2 beta1 is now released.
Previous Message 2ndQuadrant Ltd via PostgreSQL Announce 2020-10-23 12:23:58 Announcing the Release of repmgr 5.2.0