Content-Type: text/plain;
	charset=utf-8
Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3826.700.81\))
Subject: =?utf-8?Q?Re=3A_=5BANNOUNCE=5D_BISCUIT_=E2=80=93_A_Bitmap-Based_I?=
 =?utf-8?Q?ndexed_Search_Extension_for_PostgreSQL?=
From: =?utf-8?Q?Micha=C5=82_K=C5=82eczek?= <michal@kleczek.org>
In-Reply-To: <CAHi-N2GngBrYQJozySQJjKg-3Fv-5KwoFwQr_5fqwC91XrLQVQ@mail.gmail.com>
Date: Sun, 2 Nov 2025 08:53:22 +0100
Cc: pgsql-announce@postgresql.org,
 pgsql-general@postgresql.org
Content-Transfer-Encoding: quoted-printable
Message-Id: <E6155AA8-09D5-4521-B3F9-6C0B150347D2@kleczek.org>
References: <CAHi-N2GngBrYQJozySQJjKg-3Fv-5KwoFwQr_5fqwC91XrLQVQ@mail.gmail.com>
To: Sivaprasad <sivaprasad.off@gmail.com>
Archived-At: <https://www.postgresql.org/message-id/E6155AA8-09D5-4521-B3F9-6C0B150347D2%40kleczek.org>
Precedence: bulk


> On 2 Nov 2025, at 07:58, Sivaprasad <sivaprasad.off@gmail.com> wrote:
>=20
> Hi all,
>=20
> I'm excited to announce the release of BISCUIT, a new PostgreSQL
> extension focused on
> deterministic pattern matching using bitmaps and logical operations.
>=20
> Unlike pg_trgm, BISCUIT is deterministic =E2=80=94 no verification =
required.
> It uses bitmap-based indexing to accelerate complex LIKE and pattern
> queries with
> significant performance gains.
>=20
> Available on PGXN: https://pgxn.org/dist/biscuit/
> Source & Docs: https://github.com/crystallinecore/biscuit
>=20
> Key features:
> - Bitmap-based indexed pattern matching
> - Deterministic and exact results
> - Works seamlessly with PostgreSQL indexing
> - Lightweight, portable C extension
>=20
> 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?

=E2=80=94
Michal=