timescale/pg_textsearch: PostgreSQL extension for BM25 relevance-ranked full-text search
PostgreSQL extension for BM25 relevance-ranked full-text search. Postgres OSS licensed. - Github timescale/pg_textsearch
GitHub - Biscuit: A PostgreSQL index access method (IAM) for blazing-fast pattern matching on LIKE queries
github.comSaved December 16, 2025
Summary
Biscuit is a PostgreSQL index access method optimized for high-performance LIKE/ILIKE pattern matching, including multi-column searches, using bitmap position indices and length bitmaps to avoid heap rechecks.
It stores primary index structures in memory with Roaring bitmap compression and provides SQL utilities and a view to inspect in-memory vs on-disk index size. Usage involves creating biscuit indexes on text and other convertible types and benefits from multiple algorithmic optimizations such as negative indexing, wildcard skipping, and early termination on empty bitmap intersections.
