Show HN: Postgres extension for BM25 relevance-ranked full-text search (github.com)

Timescale’s open-source pg_textsearch is a PostgreSQL extension that adds BM25-based, relevance-ranked full-text search using a simple ORDER BY ... <@> syntax. It integrates with existing PostgreSQL text search configurations (e.g., english/french/german), supports fast top‑k retrieval via Block-Max WAND, and can build indexes in parallel and on partitioned tables. The project targets PostgreSQL 17–18 and is marked as production-ready (v1.0.0), with options to tune BM25 parameters and manage index segments for performance.

April 01, 2026 09:52 Source: Hacker News