Re: [ANNOUNCE] BISCUIT – A Bitmap-Based Indexed Search Extension for PostgreSQL
Michał Kłeczek <michal@kleczek.org>
From: Michał Kłeczek <michal@kleczek.org>
To: Sivaprasad <sivaprasad.off@gmail.com>
Cc: pgsql-announce@postgresql.org,
pgsql-general@postgresql.org
Date: 2025-11-02T07:53:22Z
Lists: pgsql-general
> On 2 Nov 2025, at 07:58, Sivaprasad <sivaprasad.off@gmail.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