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:
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...
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...
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
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
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...
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-...
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"
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...
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
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_...
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 has raised a $12M Series A to bring Elasticsearch workloads to Postgres.
Read it on TechCrunch: techcrunch.com/2025/07/15/p...
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 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...
