--- title: AI Has Changed Databases Forever… Here’s How | daily.dev description: PG text search brings BM25 ranking algorithm directly into PostgreSQL, eliminating the need for external search tools like Elasticsearch. Unlike PostgreSQL's... canonical: https://daily.dev/posts/ai-has-changed-databases-forever-here-s-how-kgmwnyry1 twitter:card: summary_large_image twitter:site: @dailydotdev og:type: website og:site_name: daily.dev og:title: AI Has Changed Databases Forever… Here’s How | daily.dev og:description: PG text search brings BM25 ranking algorithm directly into PostgreSQL, eliminating the need for external search tools like Elasticsearch. Unlike PostgreSQL's... og:url: https://daily.dev/posts/ai-has-changed-databases-forever-here-s-how-kgmwnyry1 og:image: https://api.daily.dev/og/posts/kGMwNyrY1.png og:image:alt: AI Has Changed Databases Forever… Here’s How og:image:width: 1200 og:image:height: 630 og:locale: en --- > ## Documentation Index > Fetch the complete documentation index at: https://daily.dev/llms.txt > Use this file to discover all available pages before exploring further. # AI Has Changed Databases Forever… Here’s How **[Tech With Tim](https://daily.dev/sources/TechWithTim)** · 17 min read · 1 upvotes · 0 comments ## Summary PG text search brings BM25 ranking algorithm directly into PostgreSQL, eliminating the need for external search tools like Elasticsearch. Unlike PostgreSQL's native full-text search which lacks proper ranking signals, BM25 provides inverse document frequency, term frequency saturation, and length normalization for better search quality. This is particularly important for AI applications like RAG systems where search quality directly impacts LLM output. The extension is open source, transactional (auto-syncing), and can be combined with pgvector for hybrid keyword and semantic search within a single database. ## Full article daily.dev links to this article rather than hosting it. Read it at the original source: ## Similar posts on daily.dev - [Better Relevance for AI Apps With BM25 Algorithm in PostgreSQL](https://daily.dev/posts/better-relevance-for-ai-apps-with-bm25-algorithm-in-postgresql-wrgphmk6m) · The New Stack · 1 upvotes · 0 comments - [Watch Out Elasticsearch\! Tiger Data's PostgreSQL BM25 Search Extension Goes Open Source](https://daily.dev/posts/watch-out-elasticsearch-tiger-data-s-postgresql-bm25-search-extension-goes-open-source-i9m2ohtmp) · It's Foss · 32 upvotes · 0 comments - [GitHub - timescale/pg\_textsearch: PostgreSQL extension for BM25 relevance-ranked full-text search. Postgres OSS licensed.](https://daily.dev/posts/github---timescale-pg-textsearch-postgresql-extension-for-bm25-relevance-ranked-full-text-search-p-xeiapecnq) · Hacker News · 11 upvotes · 0 comments --- Tags: [#ai](https://daily.dev/tags/ai), [#backend](https://daily.dev/tags/backend), [#postgresql](https://daily.dev/tags/postgresql), [#rag](https://daily.dev/tags/rag) [View this post on daily.dev](https://daily.dev/posts/ai-has-changed-databases-forever-here-s-how-kgmwnyry1) ```json {"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://daily.dev/#organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180},"sameAs":["https://twitter.com/dailydotdev","https://github.com/dailydotdev","https://www.linkedin.com/company/daily-dev-ltd"]},{"@type":"WebSite","@id":"https://daily.dev/#website","url":"https://daily.dev","name":"daily.dev","publisher":{"@id":"https://daily.dev/#organization"},"potentialAction":{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https://daily.dev/search?q={search_term_string}"},"query-input":"required name=search_term_string"}}]} {"@context":"https://schema.org","@type":"TechArticle","headline":"AI Has Changed Databases Forever… Here’s How","url":"https://daily.dev/posts/ai-has-changed-databases-forever-here-s-how-kgmwnyry1","mainEntityOfPage":{"@type":"WebPage","@id":"https://daily.dev/posts/ai-has-changed-databases-forever-here-s-how-kgmwnyry1"},"datePublished":"2026-01-22T12:54:20.201Z","dateModified":"2026-01-22T12:54:44.169Z","description":"PG text search brings BM25 ranking algorithm directly into PostgreSQL, eliminating the need for external search tools like Elasticsearch. Unlike PostgreSQL's...","image":"https://i.ytimg.com/vi/XEiQV4zRC-U/sddefault.jpg","thumbnailUrl":"https://i.ytimg.com/vi/XEiQV4zRC-U/sddefault.jpg","isAccessibleForFree":true,"articleSection":"Tech With Tim","inLanguage":"en","publisher":{"@type":"Organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180}},"author":{"@type":"Organization","name":"Tech With Tim","logo":"https://media.daily.dev/image/upload/s--6vVIDfU0--/f_auto/v1711726146/logos/TechWithTim","url":"https://daily.dev/sources/TechWithTim"},"commentCount":0,"discussionUrl":"https://daily.dev/posts/ai-has-changed-databases-forever-here-s-how-kgmwnyry1","interactionStatistic":[{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":1},{"@type":"InteractionCounter","interactionType":{"@type":"CommentAction"},"userInteractionCount":0}],"keywords":"ai,backend,postgresql,rag","timeRequired":"PT17M","video":{"@type":"VideoObject","name":"AI Has Changed Databases Forever… Here’s How","description":"PG text search brings BM25 ranking algorithm directly into PostgreSQL, eliminating the need for external search tools like Elasticsearch. Unlike PostgreSQL's...","thumbnailUrl":"https://i.ytimg.com/vi/XEiQV4zRC-U/sddefault.jpg","uploadDate":"2026-01-22T12:54:20.201Z","duration":"PT17M","url":"https://api.daily.dev/r/kGMwNyrY1","embedUrl":"https://www.youtube.com/embed/XEiQV4zRC-U"}} {"@context":"https://schema.org","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://daily.dev"},{"@type":"ListItem","position":2,"name":"Tech With Tim","item":"https://daily.dev/sources/TechWithTim"},{"@type":"ListItem","position":3,"name":"AI Has Changed Databases Forever… Here’s How"}]} ```