From: | Marc Munro <marc(at)bloodnok(dot)com> |
---|---|
To: | pgsql-announce(at)postgresql(dot)org |
Subject: | pgbitmap 0.9.1 |
Date: | 2020-09-02 16:16:49 |
Message-ID: | 1599063409.12380.32.camel@bloodnok.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-announce |
Announcing the new Beta release of pgbitmap, available from pgxn.
pgbitmap provides a bitmap datatype for postgres with a full set of
functions and operators.
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
The pgxn page is here:
https://pgxn.org/dist/pgbitmap/0.9.1/
__
Marc
From | Date | Subject | |
---|---|---|---|
Next Message | Stacey Haysler | 2020-09-02 17:18:26 | Call for New Members for the Community Code of Conduct Committee |
Previous Message | Gilles Darold | 2020-08-31 07:02:49 | pgFormatter 4.4 released |