Skip to content
This repository has been archived by the owner on Feb 26, 2021. It is now read-only.

Latest benchmark figures for PostgreSQL

Diego Vega edited this page Feb 6, 2018 · 12 revisions

Database-only tests

Threads
64 96 128 256
Windows JDBC (sync) 109358 121188 123782 124397
Npgsql sync 104719 97986 91940 63892
Npgsql async 108204 108894 111277 100632
Peregrine (async) 113204 117263 120179 !
Linux JDBC 118588 122036 122778 123125
Npgsql sync 64249 33630 28246
Npgsql async

Web database tests

Threads
64 96 128 256
Windows Npgsql async 123284/91 124532/91 124683/91 123890/91
Npgsql sync
Peregrine (async)
Linux Npgsql async 99495 93808 100055 98615
Npgsql sync
Peregrine (async)

Benchmark details

All benchmarks on the physical machines, against external database, for 2 minutes. Npgsql used perfhacks branch, bec42649e324bd39331b33e30d6800d45a1818f8.

Machines are physical Intel Xeon E5-1650 @ 3.50Ghz, 6 physical cores, 12 threads. 32GB DDR4.

Linux web cmdline:

dotnet.exe run --server "http://asp-perf-lin:5001" --client "http://asp-perf-load:5002" --jobs ../Benchmarks/benchmarks.html.json -n DbFortunesRaw --database PostgreSql --webHost KestrelSockets --repository "https://github.com/roji/benchmarks@perfhacks" --duration 120 --clientThreads 256
Clone this wiki locally