Обсуждение: [ANNOUNCE] BISCUIT – A Bitmap-Based Indexed Search Extension for PostgreSQL

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!

Best regards,
Sivaprasad Murali
Author, BISCUIT Extension

> 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

On 11/1/25 23:58, Sivaprasad wrote:
> Hi all,

FYI, this:

https://www.postgresql.org/list/pgsql-announce/

"Announcement list pertaining to PostgreSQL and various third party 
software."

is the announcement list.

> 
> 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!
> 
> Best regards,
> Sivaprasad Murali
> Author, BISCUIT Extension
> 
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com

On 11/2/25 07:21, Adrian Klaver wrote:
> On 11/1/25 23:58, Sivaprasad wrote:
>> Hi all,
> 
> FYI, this:
> 
> https://www.postgresql.org/list/pgsql-announce/
> 
> "Announcement list pertaining to PostgreSQL and various third party 
> software."
> 
> is the announcement list.
> 

My mistake. I see you sent to --announce also after I got a bounce on 
that list from my reply.

>> Best regards,
>> Sivaprasad Murali
>> Author, BISCUIT Extension
>>
>>
> 
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com

No problem, thanks!

On Sun, Nov 2, 2025 at 8:57 PM Adrian Klaver <adrian.klaver@aklaver.com> wrote:
>
> On 11/2/25 07:21, Adrian Klaver wrote:
> > On 11/1/25 23:58, Sivaprasad wrote:
> >> Hi all,
> >
> > FYI, this:
> >
> > https://www.postgresql.org/list/pgsql-announce/
> >
> > "Announcement list pertaining to PostgreSQL and various third party
> > software."
> >
> > is the announcement list.
> >
>
> My mistake. I see you sent to --announce also after I got a bounce on
> that list from my reply.
>
> >> Best regards,
> >> Sivaprasad Murali
> >> Author, BISCUIT Extension
> >>
> >>
> >
> >
>
>
> --
> Adrian Klaver
> adrian.klaver@aklaver.com