#pg_textsearch
April 7, 2026 at 4:02 PM
Discover how `pg_textsearch` transforms full-text search in Postgres with BM25 scoring, faster queries, and native integration. The benchmarks speak volumes!

#best-practice #database #development #postgresql #reading-list #tools
pg_textsearch: How we built a BM25 search engine on Postgres pages
#best-practice #database #development #postgresql #reading-list #tools
www.tigerdata.com
May 10, 2026 at 8:05 AM
#PostgreSQL #in-process with #vectorsearch extensions directly #embedded in your #Python app. #OpenSource Apache 2.0 lic

- Similarly search: #pgvector + #pgvectorscale, high-performance storage
- #FullText search: #pg_textsearch, #BM25 and #ranking
#AI #LLM #Embeddings #Agents #RAG
GitHub - Ladybug-Memory/pgembed: Embedded PostgreSQL for Agents
Embedded PostgreSQL for Agents. Contribute to Ladybug-Memory/pgembed development by creating an account on GitHub.
github.com
October 3, 2026 at 2:12 PM
pg_textsearch : Modern ranked text search for Postgres. github.com/timescale/pg...
GitHub - timescale/pg_textsearch: PostgreSQL extension for BM25 relevance-ranked full-text search. Postgres OSS licensed.
PostgreSQL extension for BM25 relevance-ranked full-text search. Postgres OSS licensed. - timescale/pg_textsearch
github.com
December 19, 2025 at 9:29 AM
pg_textsearch: PostgreSQL extension for BM25 relevance-ranked full-text search https://lobste.rs/s/n0gjzd ##databases
GitHub - timescale/pg_textsearch: PostgreSQL extension for BM25 relevance-ranked full-text search. Postgres OSS licensed.
PostgreSQL extension for BM25 relevance-ranked full-text search. Postgres OSS licensed. - timescale/pg_textsearch
github.com
December 18, 2025 at 4:50 PM
pg_textsearch - powerful PostgreSQL extension that brings modern BM25 relevance-ranked full-text search capabilities directly to your db.

osrepos.com/repo/timesca...

It offers a simple syntax, configurable parameters, and integrates seamlessly with existing PostgreSQL text search configurations.
pg_textsearch: Modern BM25 Full-Text Search for PostgreSQL
pg_textsearch is a powerful PostgreSQL extension that brings modern BM25 relevance-ranked full-text search capabilities directly to your database. It offers a simple syntax, configurable parameters, a...
osrepos.com
June 13, 2026 at 9:41 PM
I'm so grateful to Timescale for open sourcing this!
GitHub - timescale/pg_textsearch: PostgreSQL extension for BM25 relevance-ranked full-text search. Postgres OSS licensed.
PostgreSQL extension for BM25 relevance-ranked full-text search. Postgres OSS licensed. - timescale/pg_textsearch
github.com
December 19, 2025 at 3:54 AM
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.…
#hackernews #news
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.
hackernoon.com
April 9, 2026 at 3:48 AM
Tiger Data's pg_textsearch, a new open source Postgres extension, uses the BM25 algorithm to improve relevance and performance in keyword search.
Better Relevance for AI Apps With BM25 Algorithm in PostgreSQL
Tiger Data's pg_textsearch, a new open source Postgres extension, uses the BM25 algorithm to improve relevance and performance in keyword search.
bit.ly
December 24, 2025 at 7:20 PM
Tiger Data's pg_textsearch, a new open source Postgres extension, uses the BM25 algorithm to improve relevance and performance in keyword search.
Better Relevance for AI Apps With BM25 Algorithm in PostgreSQL
Tiger Data's pg_textsearch, a new open source Postgres extension, uses the BM25 algorithm to improve relevance and performance in keyword search.
bit.ly
December 27, 2025 at 9:00 PM
Second: hybrid search, natively.

pgvectorscale (our improved fork) for semantic search - higher throughput, better recall, lower latency than pgvector.

pg_textsearch (new extension) implements BM25 for ranked keyword search. In-memory for now, disk-based segments with compression coming soon.
October 21, 2025 at 2:17 PM
Matching 25) scoring algorithm for highly accurate relevance scoring. This extension requires PostgreSQL 17 or later and is supported on PostgreSQL release R20260712.01_06 or later. For more information, see Full-text search using pg_textsearch.
September 17, 2026 at 7:40 AM
Cloud SQL Postgres update on September 14, 2026 https://docs.cloud.google.com/sql/docs/postgres/release-notes#September_14_2026 #googlecloud You can use the pg_textsearch extension in Cloud SQL for PostgreSQL to perform full-text search using the industry-standard BM25 (Best
September 17, 2026 at 7:40 AM
Ribeiro, Garrido, Christiansen, Jonker, Matos: BIT.UA at BioASQ 14B: Modular Retrieval with pg_textsearch and Qdrant, and Agent-Based Answer Generation https://arxiv.org/abs/2609.04999 https://arxiv.org/pdf/2609.04999 https://arxiv.org/html/2609.04999
September 7, 2026 at 6:40 AM
pg_textsearch reports 2.4x-6.5x faster BM25 than ParadeDB at 138M docs.
Embeddings sit next to their rows, killing dual-write drift outages.
https://botmonster.com/coding/postgres-18-entire-stack-jsonb-pgvector-queues-search/?utm_source=bluesky&utm_medium=social
August 11, 2026 at 4:06 PM
You can use the pg_textsearch extension to create BM25 indexes and optimize probabilistic ranking of full-text search. This feature is supported on AlloyDB instances running PostgreSQL 17 or 18. For more information, see Create and manage a BM25 index.
August 4, 2026 at 6:40 PM
pg_textsearch — Postgres Gets a Search Engine and I No Longer Need to Justify Running Elasticsearch

An AI agent reviews Tiger Data's pg_textsearch extension, which brings BM25 full-text search to PostgreSQL and might finally kill the 'do I really…

https://theagentpost.co/posts/review-pg-textsearch
pg_textsearch — Postgres Gets a Search Engine and I No Longer Need to Justify Running Elasticsearch
An AI agent reviews Tiger Data's pg_textsearch extension, which brings BM25 full-text search to PostgreSQL and might finally kill the 'do I really need Elasticsearch?' debate.
theagentpost.co
April 1, 2026 at 2:04 PM
February 28, 2026 at 9:24 AM