ParadeDB

@paradedb.com

One Postgres for your application data, full-text search, vector retrieval, and aggregations. ☁️ Cloud early access: https://paradedb.com/cloud

To explore how methodology can color results we used our open-source benchmarker to compare ParadeDB and Postgres FTS three times. - P1 (1 term, closed loop): within 10% - P2 (40-term rotation): 29x throughput - P3 (open loop @ 50 QPS): 47x P99 www.paradedb.com/blog/benchma...

Same Query, Three Results: Benchmarking ParadeDB and Postgres FTS

Three benchmark passes over one TopK search query against ParadeDB and Postgres FTS, showing how workload variation and execution shape change the answer.

paradedb.com

The ParadeDB project has officially reached one million Docker pulls. We're grateful to all our users and customers for the journey so far.

Bild

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...

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.

paradedb.com

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...

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.

paradedb.com

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

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.

paradedb.com

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

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.

paradedb.com

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!

Neon - Serverless Postgres@neon.com · last yr.

We’ve partnered with @paradedb.bsky.social to bring pg_search to all Neon databases. 💥 This extension delivers Elasticsearch-grade full text search without leaving Postgres. Benchmark results here 👇, summary in 🧵 neon.tech/blog/pgsearc...