Latest benchmark figures for PostgreSQL

Database-only tests

		Threads
		64	96	128	256
Windows	JDBC (sync)
	Npgsql sync
	Npgsql async
	Peregrine (async)
Linux	JDBC	169215	168795	168608	164875
	Npgsql sync	48930	24064	14218	8948
	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.

Running the database-only tests

Linux JDBC:

1. ssh to aspnet@asp-perf-lin
2. If you need to build, cd to ~/roji/jdbc, the Dockerfile and benchmarking app are here.
3. docker run -it java
4. /JdbcPerfTest/out/production
5. java -cp /JdbcPerfTest/out/production/jdbc-perf-test:../../lib/HikariCP-2.7.6.jar:../../lib/slf4j-api-1.7.25.jar:../../lib/p
ostgresql-42.2.1.jar com.company.Main "jdbc:postgresql://10.0.0.103/hello_world?user=benchmarkdbuser&password=****" <threads> <seconds>

Linux ADO:

1. ssh to aspnet@asp-perf-lin
2. If you need to build, cd to ~/roji/ado, the Dockerfile and benchmarking app are here.
3. docker run -t roji-ado
4. cd /AdoPerfTest/ado-perf-test
5. dotnet run -c Release "Server=10.0.0.103;Database=hello_world;User Id=benchmarkdbuser;Password=*****;Maximum Pool Size=1024;NoResetOnClose=true" <threads> <seconds> <sync or async>

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