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
PostgreSQL Extension
Summary
Biscuit is a PostgreSQL index access method that accelerates LIKE and ILIKE pattern‑matching queries by storing bitmap-based index structures in memory. It adds utilities for inspecting the in‑memory footprint of indexes and supports multi‑column searches without the recheck cost of trigram indexes.
Highlights
- Provides a specialized IAM for fast LIKE/ILILE pattern matching, including multi‑column support.
- Stores primary index structures in memory with Roaring bitmap compression and offers SQL functions to inspect memory usage versus on‑disk size.
- Removes redundant bitmaps and unifies length‑based filtering for case‑sensitive and case‑insensitive searches, improving performance.
auto-generated
Context
Audience
Database administrators and developers who need high‑performance text search capabilities in PostgreSQL
DomainDatabase Performance
Formatopen source software repository
Accessfree online
Topics
Related
PostgreSQL GIN/GiST indexespg_trgm extensionCRoaring libraryB-Tree and hash indexes