What is ParadeDB?

ParadeDB is an Elasticsearch alternative built on Postgres. We’re modernizing the features of Elasticsearch, starting with real-time search and analytics.

ParadeDB is not a fork of Postgres, but regular Postgres with custom extensions installed. ParadeDB itself ships with Postgres 16.

Why ParadeDB

Today, developers implementing search and analytics over Postgres face one of two options: adopt an external service like Elasticsearch, which is powerful but painful to run, tune, and sync, or use Postgres’ native search and aggregations, which lack functionality and perform poorly over large datasets.

ParadeDB aims to be the best of both worlds, providing developers with the familiarity of Postgres and the performance of a dedicated search and analytical database.

ParadeDB is a good fit for:

  • Full-text, similarity, or hybrid search over large volumes of operational data
  • Backends that are bottlenecked by Postgres’ analytical performance over hundreds of millions or billions of rows
  • OLAP-style (i.e. analytical) workloads that also require an OLTP (i.e transactional) data store for frequently-updated data or metadata retrieval
  • Developers who trust Postgres and want data products within the Postgres ecosystem

Get Started

The fastest way to create an instance is by pulling the ParadeDB docker image and running it locally.

docker run \
  --name paradedb \
  -e POSTGRESQL_USERNAME=<user> \
  -e POSTGRESQL_PASSWORD=<password> \
  -e POSTGRESQL_DATABASE=<dbname> \
  -e POSTGRESQL_POSTGRES_PASSWORD=<superuser_password> \
  -v paradedb_data:/bitnami/postgresql \
  -p 5432:5432 \
  -d \
  paradedb/paradedb:latest

You may set user, password, and dbname to whatever values you want — these will be your database connection credentials. By default, this will start a ParadeDB instance at http://localhost:5432.

To connect to ParadeDB, install a Postgres client like psql and run

psql -h <hostname> -U <user> -d <dbname> -p <port> -W

Next Steps

You’re now ready to jump into our search or analytics quickstart guides.