| From: | Michał Kłeczek <michal(at)kleczek(dot)org> |
|---|---|
| To: | Sivaprasad <sivaprasad(dot)off(at)gmail(dot)com> |
| Cc: | pgsql-announce(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: [ANNOUNCE] BISCUIT – A Bitmap-Based Indexed Search Extension for PostgreSQL |
| Date: | 2025-11-02 07:53:22 |
| Message-ID: | E6155AA8-09D5-4521-B3F9-6C0B150347D2@kleczek.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> On 2 Nov 2025, at 07:58, Sivaprasad <sivaprasad(dot)off(at)gmail(dot)com> wrote:
>
> Hi all,
>
> I'm excited to announce the release of BISCUIT, a new PostgreSQL
> extension focused on
> deterministic pattern matching using bitmaps and logical operations.
>
> Unlike pg_trgm, BISCUIT is deterministic — no verification required.
> It uses bitmap-based indexing to accelerate complex LIKE and pattern
> queries with
> significant performance gains.
>
> Available on PGXN: https://pgxn.org/dist/biscuit/
> Source & Docs: https://github.com/crystallinecore/biscuit
>
> Key features:
> - Bitmap-based indexed pattern matching
> - Deterministic and exact results
> - Works seamlessly with PostgreSQL indexing
> - Lightweight, portable C extension
>
> Feedback and contributions are welcome!
Looks very interesting but I am trying to understand why
it is not implemented as IAM plugin (ie. another index type) or GIST extension?
—
Michal
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kai Wagner | 2025-11-02 10:14:58 | Re: Enquiry about TDE with PgSQL |
| Previous Message | Sivaprasad | 2025-11-02 06:58:41 | [ANNOUNCE] BISCUIT – A Bitmap-Based Indexed Search Extension for PostgreSQL |