2019-01-10

CockroachDB 2.1.3 Benchmark

Redoing the old benchmark on my office's Mac, I have installed cockroachdb on Mac using
brew install cockroach

Start the server
cockroach start --insecure --listen-addr=localhost  

Create the database
cockroach sql --insecureCREATE DATABASE test3;GRANT ALL ON DATABASE test3 TO test3; 

And do the benchmark:

alias time='/usr/local/bin/gtime -f "\nCPU: %Us\tReal: %es\tRAM: %MKB"'


time go run cockroach.go lib.go

INSERT: 1.653080201s (0.17 ms/op)
UPDATE: 1.947936008s (0.19 ms/op)

SELECT: 1m44.425784366s (1.60 ms/op: 65096)


CPU: 43.20s Real: 108.71s RAM: 89072KB

The benchmark performed on i7-4770HQ, 16GB RAM, SSD harddisk, with OSX Mojave 10.14.2 under Go 1.11. Conclusion: the result is really impressive :3 Great job CockroachDB Team.