ParadeDB
@paradedb.com
📤 224
📥 2
📝 23
Simple, Elastic-quality seach for Postgres ⭐ Star us:
http://github.com/paradedb/paradedb
We’re proud to be partnering with Modern Treasury to deliver fast, accurate search across their suite of money movement UIs and APIs.
www.paradedb.com/customers/ca...
loading . . .
ParadeDB Powers Modern Treasury's Core UI and Search APIs
How Modern Treasury replaced legacy indexes and roll-up tables with ParadeDB, eliminating query timeouts and increasing write speeds by 2-3x.
https://www.paradedb.com/customers/case-study-modern-treasury
1 day ago
0
1
1
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...
loading . . .
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,...
https://www.paradedb.com/blog/tantivy-interview
11 days ago
0
4
3
We're proud to partner with Terrapin to improve the search experience on their bond platform.
www.paradedb.com/customers/ca...
loading . . .
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.
https://www.paradedb.com/customers/case-study-terrapin-finance
15 days ago
0
3
1
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=...
loading . . .
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…
https://luma.com/2g3exvjw?tk=29GTzU
about 1 month ago
0
4
3
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...
loading . . .
How We Optimized Top K in Postgres
How ParadeDB uses principles from search engines to optimize Postgres' Top K performance.
https://www.paradedb.com/blog/optimizing-top-k
about 2 months ago
0
3
2
ParadeDB is now supported on NixOS.
#nix
about 2 months ago
0
3
1
It is now possible to reference the ParadeDB Skill directly via npx:
add a skeleton here at some point
about 2 months ago
0
2
1
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:
2 months ago
0
4
2
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...
loading . . .
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.
https://www.paradedb.com/blog/personalized-search-in-postgresql
3 months ago
0
2
1
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...
loading . . .
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.
https://www.paradedb.com/blog/increased-write-performance
3 months ago
0
4
1
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
loading . . .
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.
https://www.paradedb.com/blog/faceting
4 months ago
0
5
2
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
loading . . .
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.
https://www.paradedb.com/blog/v2api
4 months ago
0
7
2
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...
loading . . .
Blog
Engineering deep dives, product and company announcements, and guides from the ParadeDB team.
https://www.paradedb.com/blog/paradedb-0-20-0
5 months ago
0
2
2
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-...
loading . . .
Hybrid Search in PostgreSQL: The Missing Manual
Build production-ready hybrid search that combines BM25 lexical matching with vector similarity search, all inside PostgreSQL
https://www.paradedb.com/blog/hybrid-search-in-postgresql-the-missing-manual
6 months ago
0
3
0
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"
loading . . .
From Text to Token: How Tokenization Pipelines Work
Understanding how search engines transform text into tokens through character filtering, tokenization, stemming, and stopword removal.
https://www.paradedb.com/blog/when-tokenization-becomes-token
6 months ago
0
4
1
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...
loading . . .
Postgres vs. Elasticsearch: Instacart’s Unexpected Winner in High-Stakes Search with Ankit Mittal
YouTube video by The Data Engineering Show - Podcast
https://www.youtube.com/watch?v=hohp-Dmo_R0
7 months ago
0
1
0
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
loading . . .
ParadeDB
The Transactional Elasticsearch Alternative
https://www.paradedb.com/blog/elasticsearch-was-never-a-database
7 months ago
0
8
4
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_...
loading . . .
ParadeDB
Zero-ETL search and analytics for Postgres
https://www.paradedb.com/blog/etl_vs_logical_replication
8 months ago
0
8
3
We're proud to be partnering with Bilt to improve the member search experience with minimal infrastructure overhead.
www.paradedb.com/blog/case_st...
loading . . .
ParadeDB
Zero-ETL search and analytics for Postgres
https://www.paradedb.com/blog/case_study_bilt
9 months ago
0
3
1
ParadeDB has raised a $12M Series A to bring Elasticsearch workloads to Postgres. Read it on TechCrunch:
techcrunch.com/2025/07/15/p...
loading . . .
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.
https://techcrunch.com/2025/07/15/paradedb-takes-on-elasticsearch-as-interest-in-postgres-explodes-amid-ai-boom/
9 months ago
0
5
1
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...
loading . . .
ParadeDB
Zero-ETL search and analytics for Postgres
https://www.paradedb.com/blog/lsm_trees_in_postgres
10 months ago
0
11
4
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!
add a skeleton here at some point
about 1 year ago
0
1
0
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...
loading . . .
ParadeDB
Zero-ETL search and analytics for Postgres
https://www.paradedb.com/blog/block_storage_part_one
over 1 year ago
0
14
7
you reached the end!!
feeds!
log in