Postgres extension for BM25 relevance-ranked full-text search

Last summer we faced a conundrum at my company, Tiger Data, a Postgres cloud vendor whose main business is in timeseries data. We were trying to grow our business towards emerging AI-centric workloads and wanted to provide a state-of-the-art hybrid search stack in Postgres. We'd already built pgvectorscale in house with the goal of scaling semantic search beyond pgvector's main memory limitations. We just needed a scalable ranked keyword search solution too.The problem: core Postgres doesn't provide this; the leading Postgres BM25 extension, ParadeDB, is guarded behind AGPL; developing our own extension appeared daunting. We'd need a small team of sharp engineers and 6-12 months, I figured. And we'd probably still fall short of the performance of a mature system like Parade/Tantivy.Or would we? I'd be experimenting long enough with AI-boosted development at that point to realize that with the latest tools (Claude Code + Opus) and an experienced hand (I've been working in database systems internals for 25 years now), the old time estimates pretty much go out the window.I told our CTO I thought I could solo the project in one quarter. This raised some eyebrows.It did take a little more time than that (two quarters), and we got some real help from the community (amazing!) after open-sourcing the pre-release. But I'm thrilled/exhausted today to share that pg_textsearch v1.0 is freely available via open source (Postgres license), on Tiger Data cloud, and hopefully soon, a hyperscalar near you:https://github.com/timescale/pg_textsearchIn the blog post accompanying the release, I overview the architecture and present benchmark results using MS-MARCO. To my surprise, we were not only able to meet Parade/Tantivy's query performance, but exceed it substantially, measuring a 4.7x advantage on query throughput at scale:https://www.tigerdata.com/blog/pg-textsearch-bm25-fu

Hacker NewsMar 31ToolAISource

FL score

out of 100

Verdict

BUILD

high confidence

Competition

competitors found, emerging market, funded players

Trend

No signal yet

A high-performance, permissively licensed BM25 full-text search extension for Postgres, addressing key pain points of existing complex or restrictively licensed solutions.

The pain

Developers and companies using Postgres need scalable, relevance-ranked full-text search but face significant complexity, cost, and operational overhead with external solutions like Elasticsearch, or are limited by the restrictive AGPL license of Postgres extensions like ParadeDB. This results in fragile systems, slow queries, and rigid schemas.

The gap

There is a clear gap for a Postgres-native, high-performance BM25 full-text search solution that comes with a permissive open-source license. Existing alternatives are either over-engineered and costly (Elasticsearch) or have licensing that deters commercial adoption (ParadeDB AGPL). This leaves a specific unserved need for companies wanting to keep their search stack simpler and integrated within Postgres.

Build angle

Develop a Postgres extension (pg_textsearch) that provides BM25 relevance-ranked full-text search, with a permissive open-source license, focusing on superior performance and ease of integration over existing complex external systems or restrictively licensed alternatives.

Strengths

Creator has deep expertise and has already built a highly performant, open-source MVP.
Addresses a significant and specific pain point with documented user frustrations (Elasticsearch complexity, AGPL licensing).
Demonstrated superior performance (4.7x query throughput) compared to a leading competitor.
Clear market gap for a permissively licensed, Postgres-native solution.
Strong demand signals from internal company needs and general market trends towards simplified data stacks.
Growing market for AI-centric and hybrid search workloads.

Risks

Despite performance, convincing users to switch from deeply entrenched systems like Elasticsearch can be challenging.
Monetization strategy for an open-source project needs careful planning beyond cloud provider partnerships.
Ongoing maintenance and community management for an open-source database extension can be resource-intensive for a solo builder.
While the niche is clear, the broader search market is still crowded with well-funded players.
Dependency on the Postgres ecosystem for adoption and distribution.

Next steps

Focus on aggressive marketing and education within the Postgres developer community to highlight performance and licensing advantages.
Explore and formalize various monetization models (e.g., premium support, commercial features, cloud partnerships) beyond just the Tiger Data Cloud offering.
Actively engage with the open-source community for contributions, feedback, and further validation of features and use cases.
Create detailed migration guides and comparison benchmarks against more competitors to ease adoption for users currently on other platforms.

Fly Labs Method

Is the pain real, is there a gap, is it the right time, can one person build it.

Problem clarity: 28
Solution gap: 21
Willingness to pay: 20
Buildability: 16

Excellent score for a solo builder. The pain is significant and specific, a clear gap exists for a permissively licensed Postgres-native solution, and the founder has already proven buildability and performance superiority.

Value Equation

Dream outcome and how likely it feels, against the time and effort it costs.

High potential for revenue due to strong value proposition, clear differentiation, and a growing market that is actively paying for search solutions.

One-Person Business

Curiosity pull, identity fit, and a path from free value to paid for a solo creator.

Highly suitable for a solo builder given the creator's expertise and the clear problem/solution fit within a reachable niche.

Viral Frameworks

Hook strength, shareability, and how cheaply it can be tested.

Excellent viability as a micro-SaaS, leveraging a strong product, clear value, and existing distribution avenues, with a proven and clear business model.

Builder Lens

Evidence the problem exists, timing, defensibility, and a model that fits on a napkin.

A strong YC candidate with clear demand, a superior solution to a painful status quo, and significant market potential, built by an expert.

Why this verdict

This idea presents an outstanding opportunity for a solo builder. The creator has not only identified a clear and significant pain point within a growing market but has also successfully built and open-sourced a superior solution with demonstrable performance advantages. The permissive license provides a strong differentiator in a key competitive landscape (against AGPL). While the broader search market is competitive, the specific niche of 'permissive-licensed, Postgres-native BM25' is ripe for disruption. The immediate next steps involve solidifying a monetization strategy around the existing open-source success and expanding community engagement and adoption. This is a clear 'BUILD' due to validated pain, a strong solution, and a proven builder.

Five lenses, one composite. How scoring works

The angle

This weekend

Focus on aggressive marketing and education within the Postgres developer community to highlight performance and licensing advantages.
Explore and formalize various monetization models (e.g., premium support, commercial features, cloud partnerships) beyond just the Tiger Data Cloud offering.
Actively engage with the open-source community for contributions, feedback, and further validation of features and use cases.
Create detailed migration guides and comparison benchmarks against more competitors to ease adoption for users currently on other platforms.

Who is already there, emerging market

ElasticsearchFundedVisit
A distributed, RESTful search and analytics engine capable of solving a growing number of use cases.
Pricing: Elastic Cloud deployments start as low as $16/month for small instances, but production clusters typically run $500-2000+/month. Self-managed deployments have license costs plus infrastructure, often totaling thousands monthly. Enterprise pricing for self-managed solutions can be approximately $12,800 per Enterprise Resource Unit (ERU) per year.
TypesenseFundedVisit
An open-source, typo-tolerant search engine optimized for instant search experiences, designed to be fast, simple, and cost-effective.
Pricing: Typesense Cloud offers hourly pricing, with a minimal setup (0.5 GB RAM) starting around $7/month. A small production setup (4 GB RAM, shared CPU) might cost around $58/month. Larger deployments can exceed $1,000/month.
MeilisearchFundedVisit
An open-source, developer-friendly search engine designed for real-time applications, offering speed and relevance without the complexity of Elasticsearch.
Pricing: Meilisearch's transparent pricing starts at $30/month for its Build plan, including 50,000 searches and 100,000 documents. A Pro plan is available at $300/month for 250,000 searches and 1,000,000 documents. It also offers resource-based pricing.
SajariFundedVisit
An AI-driven site search platform that enhances user experience with fast, relevant results and machine learning powered ranking.
Pricing: Sajari offers a free plan for up to 20,000 queries and 20,000 records per month on one web domain. Paid plans start from $79/month for 50,000 queries and records, extending to $199/month for 250,000 queries and records with machine learning features and priority support.
ParadeDB (pg_search, pg_bm25)FundedVisit
A full-text search engine built for Postgres, powered by extensions like pg_search and pg_bm25, embedding a Rust-based Lucene alternative (Tantivy) inside Postgres.
Pricing: Pricing is not explicitly stated on the provided search results, as it's an extension for Postgres. Neon, which offers pg_search, highlights avoiding separate search service costs.
ZomboDBVisit
A Postgres extension that allows you to create Elasticsearch indexes on your PostgreSQL tables, enabling full-text search and other Elasticsearch features. (Information derived from general knowledge about ZomboDB, as detailed description was not explicit in search results)
Pricing: Not explicitly found in search results. As an open-source extension, core usage is likely free, with potential costs for support or managed services.

Funded players

What they charge

The pricing landscape for full-text search solutions is diverse. Open-source extensions for Postgres like pg_search are fundamentally free but may incur costs through managed services (e.g., Neon). Dedicated search engines like Typesense and Meilisearch offer tiered subscription models (e.g., $7-$1000+/month for Typesense Cloud based on resources, $30-$300+/month for Meilisearch based on usage tiers) and often include free trials. Larger, more established solutions like Elasticsearch have complex pricing based on resource consumption, data ingestion, and features, ranging from small instances at ~$16/month to production clusters costing thousands monthly, with significant hidden costs often associated with self-managed deployments and enterprise features. Sajari offers a generous free tier with paid plans starting around $79/month. The trend is towards transparent, predictable pricing models.

Postgres extension for BM25 relevance-ranked full-text search

Semble – Code search for agents that uses 98% fewer tokens than grep

Consus (YC F24) – LLM gateway for companies handling sensitive data

GlycemicGPT – Open-source AI-powered diabetes management