select open change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Extensions / Full-text search

pg_bestmatch

Generate BM25 sparse vector inside PostgreSQL

pgext.cloud · Source code · License text · Control file

Overview

Packagepg_bestmatch
Version0.0.2
PostgreSQL versions14 · 15 · 16 · 17 · 18
RepositoryPIGSTY
Extension typePreloaded
Requires CREATE EXTENSIONYes
Requires preloadYes
TrustedNo
RelocatableNo
Shared librariespg_bestmatch
Schemabm_catalog
Stars100
Latest commit2024-11-05
Latest release2024-10-10
Catalogue updated2026-08-30

Related extensions

See also

pg_searchFull text search for PostgreSQL using BM25
pg_textsearchFull-text search with BM25 ranking
vchord_bm25A postgresql extension for bm25 ranking algorithm
pg_ftsFull-text search with BM25 and BM25F ranking
pg_rrfReciprocal rank fusion functions for hybrid search
pgroongaUse Groonga as index, fast full text search platform for all languages!
psql_bm25sPostgreSQL extension for BM25-family lexical retrieval
vectorizeThe simplest way to do vector search on Postgres
pgcontextVector, filter-aware HNSW, and hybrid retrieval over authoritative PostgreSQL tables.