DIFF.BLOG
New Following Discover Jobs
More
Top Writers Suggest a blog Upvotes plugin
Report bug Contact About Privacy
Sign up
Topics
Follow your own topics →
Menu
New Following Discover Jobs Top Writers
More
Suggest a blog Upvotes plugin Report bug Contact About
Sign up
Privacy Policy
The home for great developer writing.
We surface the best developer writing from thousands of independent blogs, updated daily.
Join Diff.blog
TOPICS

From ts_rank to BM25. Introducing pg_textsearch: True BM25 Ranking and Hybrid Retrieval Inside Postgres

· Timescale · Oct. 23, 2025, 2:20 p.m.
Announcements & Releases AI postgresql PostgreSQL Extensions postgresql bm25 Hybrid Search Database Features
Summary
The blog post introduces pg_textsearch, a feature in PostgreSQL that implements the BM25 ranking algorithm, enabling hybrid search by combining keyword precision with vector semantics within a single database. This setup is beneficial for building retrieval-augmented generation (RAG) systems.
Read full post on www.tigerdata.com →
MORE POSTS LIKE THIS
Yes, You Can Do Hybrid Search in Postgres (And You Probably Should)
Timescale · Apr 20, 2026
pg_textsearch Cloud
Build a Hybrid Search Engine in PostgreSQL: BM25 + Vector Retrieval
freeCodeCamp.org · Oct 21, 2026
postgresql Youtube
Waiting for PostgreSQL 19 – SQL Property Graph Queries (SQL/PGQ)
select * from depesz; · Jul 31, 2026
Graph Graphs
What is psuedo-relevance feedback?
Doug Turnbull · Apr 13, 2026
Natural Language Processing Information Retrieval
[Announcing] Kova: A relational ORM with zero query macros, zero trait imports, and flat compile-time types
Users Rust Lang · Nov 10, 2026
programming software development
Getting rid of a 4 TB table in PostgreSQL
Radim Marek · Oct 31, 2026
data engineering postgresql
Discover more posts →
AUTHOR
BLOG POST FEATURED ON

Placeholder image
r/PostgreSQL

9 points

Placeholder image
Hacker News

5 points

Placeholder image
r/programming

1 points

Add this plugin to your blog
RECENT POSTS FROM THE AUTHOR
Choose how you want to continue.
Continue with GitHub Continue with Google
By continuing, you agree to our Privacy Policy.