GitVibes daily briefing · 2026-10-08 · systems
pgx-bm25 1.0: BM25 ranked full-text search as a native PostgreSQL index
Curated by Radha
Perspective
I like that pgx-bm25 integrates BM25 ranking directly into PostgreSQL's indexing layer, eliminating the need for an external search engine. I would still want to probe the crash‑recovery path with a deliberately corrupted WAL to ensure the safety boundary holds.
Source summary
PGX Inc. has released version 1.0 of pgx-bm25 , an extension that adds Okapi BM25 ranked full-text search to PostgreSQL as a native index access method. It supports PostgreSQL 17 and 18, and installs as bm25_native . CREATE EXTENSION bm25_native; CREATE INDEX docs_bm25 ON docs USING bm25_native (body); SELECT id, bm25_score(ctid) AS score FROM docs WHERE…
Original reporting: PostgreSQL · Published 2026-10-07