public inbox for [email protected]  

help / color / mirror / Atom feed

From: Sivaprasad <[email protected]>
To: [email protected]
Cc: [email protected]
Subject: [ANNOUNCE] BISCUIT 2.0 - Now a full Index Access Method with multi-column indexing
Date: Fri, 5 Dec 2025 22:54:06 +0530
Message-ID: <CAHi-N2HkdpefQT4m2gnq_hAVDFiFDrwTUWBjuHyFt5s+xEg_EA@mail.gmail.com> (raw)

Hi all,

I’m happy to share a major update to BISCUIT (Bitmap Indexed Searching
with Comprehensive Union and Intersection Techniques), which has now
evolved from a standalone extension into a full Index Access Method
(IAM) for PostgreSQL.

Since the initial release, BISCUIT has gained a mature architecture,
significant performance improvements, and broad feature support -
making it a practical alternative for deterministic pattern matching
workloads.

🔹 What’s new

1) Full Index Access Method implementation: BISCUIT now plugs directly
into PostgreSQL’s indexing framework, bringing custom index-build,
search, scan, and vacuum logic.

2) Multi-column indexing support: You can now index multiple columns
in a single BISCUIT index, enabling richer pattern-matching queries
and improved performance on composite text workloads.

3) Highly optimized storage layout: Reduced index size, faster scans,
and improved cache behavior through compact bitmap storage and logical
operation based pruning.

4) Deterministic pattern search (no verification overhead): The core
advantage remains: BISCUIT guarantees correctness without rechecking
rows, unlike trigram-based approaches.

5) Seamless integration with PostgreSQL: WAL-safe, VACUUM-aware, and
extension-managed via CREATE EXTENSION biscuit.

🔹 Where to get it

PGXN: https://pgxn.org/dist/biscuit/
GitHub: https://github.com/crystallinecore/biscuit

🔹 Call for feedback

BISCUIT is growing quickly, and real-world feedback is
invaluable-whether on performance, operator design, or additional
indexing strategies.

Thanks for the continued support and testing!

Best regards,
Sivaprasad Murali
Author, BISCUIT-IAM

view thread (2+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: [ANNOUNCE] BISCUIT 2.0 - Now a full Index Access Method with multi-column indexing
  In-Reply-To: <CAHi-N2HkdpefQT4m2gnq_hAVDFiFDrwTUWBjuHyFt5s+xEg_EA@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox