ParadeDB is an Elasticsearch alternative built on Postgres.

• GitHub
• Homepage

The published benchmarks are based on ParadeDB version v0.8.4.

To run the benchmarks:

1. Manually start an AWS EC2 instance
   • c6a.4xlarge
   • Ubuntu Server 22.04 LTS (HVM), SSD Volume Type*
   • Root 500GB gp2 SSD**
2. Wait for the status check to pass, then SSH into the instance via EC2 Instance Connect
3. Clone this repository via git clone https://github.com/ClickHouse/ClickBench
4. Navigate to the paradedb directory via cd ClickBench/paradedb
5. Run the benchmark via ./benchmark.sh. This will run the benchmarks against the default settings below.

The benchmark script takes the following parameters:

• -w - Type of workload, either single or partitioned. The default is single, meaning it uses the hits.parquet ClickBench dataset. The partitioned option uses the Clickbench partitioned dataset.

The benchmark should be completed within a few minutes. If you'd like to benchmark against a different version of ParadeDB, modify the Docker tag in the benchmark.sh script. You can find the list of available tags here.