# pgx-bm25 1.0: BM25 ranked full-text search as a native PostgreSQL index

> **Key Architectural Takeaway:** 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.

**Published:** 2026-10-07T00:00:00+00:00  
**Source:** PostgreSQL Official News  
**Category:** databases-storage  
**Canonical URL:** https://fosswire.org/news/pgx-bm25-10-bm25-ranked-full-text-search-as-a-native-postgre.html  

## Executive Summary
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 body @@@ 'quick fox' ORDER BY body &@@ 'quick fox' LIMIT 10; @@@ selects the matching rows and &@@ orders them by relevance.

## Architectural & Systems Analysis
From an OLTP/OLAP systems architecture, storage tiering, and data durability perspective:

- **Zero-Vendor Lock-in Formats:** Leveraging open specifications (e.g. Parquet, Iceberg) ensures multi-engine interoperability without ingestion lock-in.
- **Vector & In-Memory Throughput:** Modern memory layouts and SIMD-accelerated execution pipelines minimize latency in real-time retrieval.
- **Distributed Resiliency:** Decoupled storage and compute layers enable elastic horizontal scaling with strict ACID guarantees.

## Impact on the Open Ecosystem
Empowers data engineers with open, self-hosted alternatives to monopolistic cloud database providers.