public inbox for [email protected]
help / color / mirror / Atom feed[ANNOUNCE] BISCUIT 2.0 - Now a full Index Access Method with multi-column indexing
2+ messages / 2 participants
[nested] [flat]
* [ANNOUNCE] BISCUIT 2.0 - Now a full Index Access Method with multi-column indexing
@ 2025-12-05 17:24 Sivaprasad <[email protected]>
0 siblings, 1 reply; 2+ messages in thread
From: Sivaprasad @ 2025-12-05 17:24 UTC (permalink / raw)
To: [email protected]; +Cc: pgsql-general
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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: [ANNOUNCE] BISCUIT 2.0 - Now a full Index Access Method with multi-column indexing
@ 2025-12-05 17:32 Adrian Klaver <[email protected]>
parent: Sivaprasad <[email protected]>
0 siblings, 0 replies; 2+ messages in thread
From: Adrian Klaver @ 2025-12-05 17:32 UTC (permalink / raw)
To: Sivaprasad <[email protected]>; [email protected]; +Cc: pgsql-general
On 12/5/25 09:24, Sivaprasad wrote:
> 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.
The appropriate list for this is:
https://www.postgresql.org/list/pgsql-announce/
--
Adrian Klaver
[email protected]
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2025-12-05 17:32 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2025-12-05 17:24 [ANNOUNCE] BISCUIT 2.0 - Now a full Index Access Method with multi-column indexing Sivaprasad <[email protected]>
2025-12-05 17:32 ` Adrian Klaver <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox