pg_textsearch Demo

BM25 + Hybrid Search for PostgreSQL

Docs →
Show:
Try these examples to see how different search methods compare:
Keyword Search
🤖 Agentic Queries
BM25 Feature Examples
IDF (Rare Terms)
TF Saturation (k₁)
Length Norm (b)

Partial Match: "db" ≠ "database"

"db" doesn't match "database" — see the ✗ db in results. Native requires ALL terms to match. BM25 still returns results ranked by the terms that DO match.

Native PostgreSQL

ts_rank + Boolean AND

Run a search

BM25

pg_textsearch

Score FilterOff

Run a search

Vector

pgvectorscale + OpenAI

Run a search

Hybrid

BM25 + Vector RRF

BM25Vector
50%50%
Score FilterOff

Run a search