Page MenuHomeSoftware Heritage
Paste P491

cassandra vs postgresql read benchmark
ActivePublic

Authored by vlorentz on Aug 8 2019, 1:47 PM.
Benchmark results for content_find:
hash_algo = sha1 (sample size=263):
cassandra: avg = 9 ms, stdev = 2.5 ms
postgres: avg = 14 ms, stdev = 14.9 ms
hash_algo = sha1_git (sample size=256):
cassandra: avg = 9 ms, stdev = 2.2 ms
postgres: avg = 15 ms, stdev = 27.9 ms
hash_algo = sha256 (sample size=218):
cassandra: avg = 9 ms, stdev = 2.1 ms
postgres: avg = 14 ms, stdev = 9.4 ms
hash_algo = blake2s256 (sample size=263):
cassandra: avg = 9 ms, stdev = 2.2 ms
postgres: avg = 14 ms, stdev = 7.9 ms
Benchmark results for content_missing_per_sha1 (1 arg) (sample size=1000):
cassandra: avg = 4 ms, stdev = 0.7 ms
postgres: avg = 14 ms, stdev = 10.9 ms
Benchmark results for content_missing_per_sha1 (100 args) (sample size=1000):
cassandra: avg = 4 ms, stdev = 1.2 ms
postgres: avg = 90 ms, stdev = 43.2 ms
Benchmark results for revision_get (1 arg) (sample size=1000):
cassandra: avg = 7 ms, stdev = 1.4 ms
postgres: avg = 21 ms, stdev = 11.1 ms
Benchmark results for revision_get (100 args) (sample size=1000):
cassandra: avg = 115 ms, stdev = 18.8 ms
postgres: avg = 65 ms, stdev = 49.7 ms
Benchmark results for revision_missing (1 arg) (sample size=1000):
cassandra: avg = 3 ms, stdev = 1.2 ms
postgres: avg = 16 ms, stdev = 16.6 ms
Benchmark results for revision_missing (100 args) (sample size=1000):
cassandra: avg = 66 ms, stdev = 8.8 ms
postgres: avg = 52 ms, stdev = 35.1 ms
Benchmark results for directory_ls (1 arg) (sample size=1000):
cassandra: avg = 83 ms, stdev = 306.4 ms
postgres: avg = 40 ms, stdev = 72.7 ms
Benchmark results for directory_missing (1 arg) (sample size=1000):
cassandra: avg = 3 ms, stdev = 0.9 ms
postgres: avg = 14 ms, stdev = 11.4 ms
Benchmark results for directory_missing (100 args) (sample size=1000):
cassandra: avg = 63 ms, stdev = 9.0 ms
postgres: avg = 65 ms, stdev = 23.7 ms
Benchmark results for release_get (1 arg) (sample size=1000):
cassandra: avg = 6 ms, stdev = 1.3 ms
postgres: avg = 21 ms, stdev = 14.9 ms
Benchmark results for release_get (100 args) (sample size=1000):
cassandra: avg = 100 ms, stdev = 16.5 ms
postgres: avg = 30 ms, stdev = 14.9 ms
Benchmark results for release_missing (1 arg) (sample size=1000):
cassandra: avg = 3 ms, stdev = 0.7 ms
postgres: avg = 13 ms, stdev = 11.2 ms
Benchmark results for release_missing (100 args) (sample size=1000):
cassandra: avg = 57 ms, stdev = 9.0 ms
postgres: avg = 18 ms, stdev = 10.9 ms
Benchmark results for snapshot_get (1 arg) (sample size=1000):
cassandra: avg = 9 ms, stdev = 1.9 ms
postgres: avg = 31 ms, stdev = 17.2 ms

Event Timeline

Same comment as P489, except this time the cache is mostly cold