A Conversation with Paul Masurel, Creator of Tantivy We sat down with Paul Masurel (creator of Tantivy and co-founder of Quickwit) to talk about building a search engine in Rust, following the competitive happy-path with Lucene, open-source maintenance,...

Full-text search was solved in 2016, Lucene had owned the space for a decade. Rewriting it in Rust, as a side project, on a plane sounds like a terrible idea.

Enter Paul Masurel and Tantivy ...

www.paradedb.com/blog/tantivy...

Terrapin Finance Cuts Bond Search Latency by 25x with ParadeDB How Terrapin Finance replaced pg_trgm with ParadeDB to power sub-200ms full-text search across 1.1 billion rows of fixed-income data.

We're proud to partner with Terrapin to improve the search experience on their bond platform.

www.paradedb.com/customers/ca...

South Bay Systems: Consensus & Full Text Search · Luma Welcome to another edition of South Bay Systems! This time we bring you two wonderful talks: Sugu Sougoumarane will be speaking about deconstructing consensus…

On March 31st, @stuhood.sh will be speaking about how ParadeDB performs native Top K JOINs at South Bay Systems. We look forward to seeing you there:

luma.com/2g3exvjw?tk=...

How We Optimized Top K in Postgres How ParadeDB uses principles from search engines to optimize Postgres' Top K performance.

Top K is a deceptively hard problem in Postgres. "Give me the 10 best rows" works until you add filters and text search, then GIN can't sort and B-trees can't search.

BM25 indexes handle equality, sort, and range in one data structure. Here's why that matters:

www.paradedb.com/blog/optimiz...

ParadeDB is now supported on NixOS.

#nix

It is now possible to reference the ParadeDB Skill directly via npx:

We're launching Agent Skills and MCP Server for ParadeDB. These will empower your AI coding agent to produce top-notch, accurate ParadeDB code effortlessly.

For Skill, go to: github.com/paradedb/age...

For MCP:

Retrieve and Rerank: Personalized Search Without Leaving Postgres Build a production-grade personalized search engine entirely within Postgres using BM25 retrieval and vector-based reranking, no external infrastructure required.

Ankit (ex-Instacart) shows us how to build personalized search entirely inside PostgreSQL.

A search for “king” could mean LOTR: Return of the King or The King’s Speech.

To fix that:
• Retrieve with BM25
• Rerank with embeddings + cosine similarity

www.paradedb.com/blog/persona...

How We Made Writes 10x Faster for Search How ParadeDB achieved 10x improved write throughput through searchable buffers, background merging, and handling Postgres HOT chains.

As part of our v0.20.0 release late last year we did a lot of work on increasing write throughput.

Adding any index to a Postgres table trades off write speed for read speed, and BM25 indexes aren't any exception.

So we set out to make things better ....

www.paradedb.com/blog/increas...

14x Faster Faceted Search in PostgreSQL with ParadeDB Introducing faceted search in ParadeDB - bringing the power of search engine faceting to PostgreSQL with single-query aggregations.

Faceting looks simple, it's just counts next to search results right? But making it fast and ergonomic is harder than it seems.

We just shipped native faceting in ParadeDB: it runs inside Postgres, in a index single pass, and is 14× faster over large result sets👇

www.paradedb.com/blog/faceting

Deep Dive into ParadeDB's v2 API: The Future of SQL Search Explore ParadeDB's v2 API that eliminates schema duplication, simplifies tokenization, and provides transparent search operators for intuitive SQL-based full-text search.

We've shown you parts of our V2 SQL API over the last month, but here's a full post looking at everything you can do with it.

Check out the side by side of the CREATE TABLE for old and new APIs, it's so much better ❤️.

www.paradedb.com/blog/v2api

Blog Engineering deep dives, product and company announcements, and guides from the ParadeDB team.

We're excited to announce the release of v0.20.0. This release brings:

- Official support for accelerated facets in ParadeDB
- An order of magnitude improvement to our write throughput
- A brand new SQL interface that's more SQL-native and ORM-friendly

www.paradedb.com/blog/paraded...

Hybrid Search in PostgreSQL: The Missing Manual Build production-ready hybrid search that combines BM25 lexical matching with vector similarity search, all inside PostgreSQL

Sometimes it can be hard to work out how to assemble the LEGO to get search working in Postgres; so we wrote the Missing Manual for Hybrid Search.

If you're after a little bit of lexical, and a little bit of semantic, this is for you.

www.paradedb.com/blog/hybrid-...

From Text to Token: How Tokenization Pipelines Work Understanding how search engines transform text into tokens through character filtering, tokenization, stemming, and stopword removal.

We've got a new post out that looks at tokenization pipelines (with some cool interactive diagrams).

www.paradedb.com/blog/when-to...

Bonus points for anyone who guesses why the original title was "When Tokenization Becomes Token"

Postgres vs. Elasticsearch: Instacart’s Unexpected Winner in High-Stakes Search with Ankit Mittal YouTube video by The Data Engineering Show - Podcast

A fantastic podcast by our engineer, Ankit Mittal, on how Instacart built search on Postgres, where the future of search infrastructure is going, and why that led him to join us at ParadeDB: www.youtube.com/watch?v=hohp...

ParadeDB The Transactional Elasticsearch Alternative

People who use Elasticsearch fall into two camps: those who know it shouldn’t be used as a source of truth, and those who haven’t thought it through…

Seriously though, if you use Elastic as a database, we’d love to hear about it.

www.paradedb.com/blog/elastic...

#elasticsearch #database #search

ParadeDB Zero-ETL search and analytics for Postgres

We’ve worked with 50+ companies syncing Postgres with non-Postgres sinks like Elasticsearch. Our latest post is a deep dive into how Postgres → Postgres differs from Postgres → anything else.

www.paradedb.com/blog/etl_vs_...

ParadeDB Zero-ETL search and analytics for Postgres

We're proud to be partnering with Bilt to improve the member search experience with minimal infrastructure overhead.

www.paradedb.com/blog/case_st...

ParadeDB takes on Elasticsearch as interest in Postgres explodes amid AI boom | TechCrunch ParadeDB built a Postgres extension that facilitates full-text search and analytics on Postgres without the need to transfer data.

ParadeDB has raised a $12M Series A to bring Elasticsearch workloads to Postgres.

Read it on TechCrunch: techcrunch.com/2025/07/15/p...

ParadeDB Zero-ETL search and analytics for Postgres

The ParadeDB BM25 index brings Elastic-style full-text search to Postgres, powered by our custom Postgres-native LSM tree. Dive into how we built it:

www.paradedb.com/blog/lsm_tre...

Exciting news! We've partnered with Neon, one of the largest managed Postgres providers, to bring ParadeDB to their platform. As of this morning, pg_search is now live on Neon!

ParadeDB Zero-ETL search and analytics for Postgres

ParadeDB is now integrated with Postgres block storage.

Today, we are releasing Part 1 of our 3-part blog series on how we designed a new storage mechanism for search and analytics in Postgres.

www.paradedb.com/blog/block_s...