Horton
Menu

Thread

  1. [ANNOUNCE] BISCUIT – A Bitmap-Based Indexed Search Extension for PostgreSQL

    Sivaprasad <sivaprasad.off@gmail.com> — 2025-11-02T06:58:41Z

    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

  2. Re: [ANNOUNCE] BISCUIT – A Bitmap-Based Indexed Search Extension for PostgreSQL

    Michał Kłeczek <michal@kleczek.org> — 2025-11-02T07:53:22Z

    
> 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

  3. Re: [ANNOUNCE] BISCUIT – A Bitmap-Based Indexed Search Extension for PostgreSQL

    Adrian Klaver <adrian.klaver@aklaver.com> — 2025-11-02T15:21:05Z

    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

  4. Re: [ANNOUNCE] BISCUIT – A Bitmap-Based Indexed Search Extension for PostgreSQL

    Adrian Klaver <adrian.klaver@aklaver.com> — 2025-11-02T15:27:06Z

    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

  5. Re: [ANNOUNCE] BISCUIT – A Bitmap-Based Indexed Search Extension for PostgreSQL

    Sivaprasad <sivaprasad.off@gmail.com> — 2025-11-02T17:00:09Z

    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