timescale/pg_textsearch

Health v2 · maintenance only

Adoption not part of the score

3941 stars · 114 forks observed · 2026-08-28

What it is AI-extracted, prompt v1, taxonomy v1, 2026-08-29, confidence not recorded

A PostgreSQL extension written in C that adds BM25 relevance-ranked full-text search via a bm25 index type and the <@> ordering operator. It supports expression and partial indexes, partitioned tables, parallel index builds, and Block-Max WAND top-k optimization.

Use cases

• rank full-text search results by BM25 relevance in Postgres
• fast top-k keyword search over large document tables
• search over JSONB fields and multiple columns
• build multilingual search with Postgres text search configurations
• scoped search using partial indexes on partitioned tables

When to choose

• you need relevance-ranked (BM25) search inside PostgreSQL without an external engine
• you want simple SQL syntax like ORDER BY content <@> 'terms'
• you need high-performance top-k queries on large text tables
• you are on PostgreSQL 17 or 18

When to avoid

• you need fuzzy/typo-tolerant or vector similarity search
• you are on PostgreSQL versions older than 17
• you need a hosted search service with analytics and dashboards
• you cannot modify shared_preload_libraries on your database server

Facets

library · maturity active

search-engine database databases developer-tools self-hosted postgresql-extension bm25 full-text-search c-extension top-k-queries search linux macos

Member repositories

For agents

markdown · JSON · MCP: product_card(name="timescale/pg_textsearch")