Pg Textsearch Reviews — Discover what people think of this product.

pg_textsearch is a PostgreSQL extension that brings BM25 relevance-ranked full-text search directly into your database, without external search infrastructure. Built for modern Postgres (v17 and v18), it adds a simple syntax and powerful ranking so you can run production-grade text queries using familiar SQL.

With pg_textsearch, you can ORDER BY relevance using the <@> operator and leverage BM25 scoring with configurable parameters (k1, b). It integrates with existing Postgres text search configurations (e.g., english, french, german, german), and supports partitioned tables for scalable workloads. The extension is Postgres OSS licensed and currently in v0.1.1-dev, feature-complete but still being optimized.

Key capabilities include:

• BM25-ranked text search with negative score ordering for efficient index scans
• Embedded index name syntax and planner compatibility tailored for PostgreSQL 18
• Pre-built binaries for Linux and macOS (amd64, arm64) or straightforward build-from-source
• Simple SQL workflow: CREATE EXTENSION, CREATE INDEX USING bm25, then ORDER BY column <@> 'query'

pg_textsearch is ideal for teams who want advanced relevance ranking, tunable scoring, and tight database integration without managing a separate search stack. The roadmap focuses on performance, scalability, and deeper Postgres planner optimization so you can grow from prototypes to demanding text workloads.