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
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.
High potential for revenue due to strong value proposition, clear differentiation, and a growing market that is actively paying for search solutions.
Highly suitable for a solo builder given the creator's expertise and the clear problem/solution fit within a reachable niche.
Excellent viability as a micro-SaaS, leveraging a strong product, clear value, and existing distribution avenues, with a proven and clear business model.
One-liner
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.
Reasoning
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.
Competitors (6)- emerging
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.
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.
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.
A strong YC candidate with clear demand, a superior solution to a painful status quo, and significant market potential, built by an expert.
Risks
Strengths
Next Steps
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.
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.
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.
Pricing Landscape
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.
Recent News
Meilisearch Blog - April 09 2025
G2 - April 09 2025
Meilisearch Blog - December 10 2025
Meilisearch Blog - December 22 2025
Neon Blog - June 13 2025
Market Signals
The market for relevance-ranked full-text search, especially within the Postgres ecosystem and for AI-centric workloads, appears to be growing. There's a clear trend towards integrating advanced search capabilities directly into Postgres to simplify architecture and reduce operational overhead, driven by user frustrations with the complexity and cost of external search engines like Elasticsearch. Emerging solutions and recent news indicate an increasing demand for performant, user-friendly, and cost-effective search solutions that can handle modern requirements like hybrid search (combining full-text and vector search).
User Frustrations