Wed Mar 23 14:09:57 2022

Benchmark Report

The results below were generating using the IMDBench benchmarking suite: github.com/edgedb/imdbench.

Targets

• EdgeDB (Python)
• PostgreSQL (py-psycopg2)
• PostgreSQL (py-asyncpg)
• PostgreSQL (js-pg)
• PostgreSQL (go-pgx)

Test environment

Linux 5.16.15+ (Gentoo 2.7, x86_64) on AMD Ryzen Threadripper 3970X 32-Core Processor

Duration (per benchmark)

10 seconds

Concurrency

1 clients

Simulated client-to-database latency

~1ms

Overall Results

The charts below show the geometric average of all benchmark results.

Throughput (more is better)

Latency (less is better)

Individual benchmarks

POST /movie (existing cast)

Create a new movie record, linking existing directors and cast.

Throughput (more is better)

Latency (less is better)

Sample Outputs

GET /movie/:id

Get information about a given movie: title, year, directors, cast, recent reviews, and average review rating.

Throughput (more is better)

Latency (less is better)

Sample Outputs

GET /user/:id

Get information about a given user: name and a sample of the latest movie reviews this user authored.

Throughput (more is better)

Latency (less is better)

Sample Outputs