pg_textsearch 1.0: How We Built a BM25 Search Engine on Postgres Pages

Postgres full-text search struggles at scale due to poor ranking and no top-k optimization. pg_textsearch introduces native BM25 with Block-Max WAND, delivering better relevance and 2–6x faster queries plus 8.7x higher throughput. Built directly on Postgres storage, it removes the need for Elasticsearch sidecars while maintaining WAL, replication, and operational simplicity.