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