Postgresql
for Search

Postgresql for search

ParadeDB is a Postgres-based ElasticSearch alternative, engineered for lightning-fast full text, similarity, and hybrid search.

ParadeDB is a Postgres-based ElasticSearch alternative, engineered for lightning-fast full text, similarity, and hybrid search.

Full-fledged search inside Postgres

Full-fledged search inside Postgres

Say goodbye to gluing ElasticSearch and other services on top of Postgres. ParadeDB offers the most comprehensive, Postgres-native search features of any Postgres database.

Say goodbye to gluing ElasticSearch and other services on top of Postgres. ParadeDB offers the most comprehensive, Postgres-native search features of any Postgres database.

Full Text Search

Search by keyword or phrase with configurable tokenizers, stemming for 17 languages, and an extensible SQL-based query language.

Similarity Search

Search by semantic meaning with the pre-installed pgvector extension and workflows that incrementally keep vectors in sync.

Hybrid Search

Surface results with higher precision and recall with hybrid search, which combines the strengths of full text and similarity search.

BM25 Scoring

Full text search results are sorted by BM25, the term-based ranking algorithm used by ElasticSearch.

Faceted Search

Bucket and collect statistical metrics on search results with faceted search.

Distributed Search

ParadeDB automatically shards indexes, enabling developers to search hundreds of times faster compared to single-node Postgres.

Highlighting

Identify the most relevant portions of surfaced documents.

Autocomplete

Build smart search boxes with autocomplete, which suggests documents most similar to a search query.

Relevance Tuning

Tune your results by applying custom weights to individual fields.

Made for developers

Made for developers

100% Rust

ParadeDB's search engine is built on Tantivy, a Rust-based implementation of Apache Lucene.

Image

Web-Based Editor

An intuitive table editor makes it easy to explore your data and write queries.

Open Source

ParadeDB is developed in public and actively welcomes community contributions.

Lightning-Fast

Full text queries over one million rows return in under 100ms.

Image

modern search is built on postgres

modern search is built on postgres

© 2023 Retake, Inc. All rights reserved.

Office

169 Madison Ave #2470

New York, NY 10016

ParadeDB

© 2023 Retake, Inc. All rights reserved.

Office

169 Madison Ave #2470

New York, NY 10016

ParadeDB

© 2023 Retake, Inc. All rights reserved.

Office

169 Madison Ave #2470

New York, NY 10016

ParadeDB