Created
June 21, 2014 14:51
-
-
Save jackc/964001ba6e960d661acc to your computer and use it in GitHub Desktop.
Benchmark results of pgx (b2c1a14fcc) with Go 1.2.2 vs 1.3
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
jack@edi:~/dev/go/src/github.com/jackc/pgx$ go version | |
go version go1.2.2 linux/amd64 | |
jack@edi:~/dev/go/src/github.com/jackc/pgx$ go test -test.bench=. | |
PASS | |
BenchmarkSelectRowSimpleNarrow 50000 72011 ns/op | |
BenchmarkSelectRowPreparedNarrow 50000 45556 ns/op | |
BenchmarkSelectRowsSimpleNarrow 10000 130469 ns/op | |
BenchmarkSelectRowsPreparedNarrow 20000 81028 ns/op | |
BenchmarkSelectValuePreparedNarrow 20000 82214 ns/op | |
BenchmarkSelectValueToPreparedNarrow 50000 64362 ns/op | |
BenchmarkSelectRowsSimpleJoins 50 44918199 ns/op | |
BenchmarkSelectRowsPreparedJoins 50 44238415 ns/op | |
BenchmarkInt2Text 50000 71589 ns/op | |
BenchmarkInt2Binary 50000 64547 ns/op | |
BenchmarkInt4Text 50000 66487 ns/op | |
BenchmarkInt4Binary 50000 63442 ns/op | |
BenchmarkInt8Text 50000 67312 ns/op | |
BenchmarkInt8Binary 50000 65046 ns/op | |
BenchmarkFloat4Text 10000 114489 ns/op | |
BenchmarkFloat4Binary 50000 61476 ns/op | |
BenchmarkFloat8Text 10000 136828 ns/op | |
BenchmarkFloat8Binary 50000 64656 ns/op | |
BenchmarkBoolText 50000 63328 ns/op | |
BenchmarkBoolBinary 50000 64768 ns/op | |
BenchmarkTimestampTzText 10000 199721 ns/op | |
BenchmarkTimestampTzBinary 50000 66378 ns/op | |
BenchmarkConnPool 20000000 95.6 ns/op | |
BenchmarkQueryArgs 5000000 703 ns/op | |
ok github.com/jackc/pgx 85.939s | |
jack@edi:~/dev/go/src/github.com/jackc/pgx$ go test -test.bench=. | |
PASS | |
BenchmarkSelectRowSimpleNarrow 20000 81141 ns/op | |
BenchmarkSelectRowPreparedNarrow 50000 45259 ns/op | |
BenchmarkSelectRowsSimpleNarrow 10000 136298 ns/op | |
BenchmarkSelectRowsPreparedNarrow 20000 75763 ns/op | |
BenchmarkSelectValuePreparedNarrow 20000 75805 ns/op | |
BenchmarkSelectValueToPreparedNarrow 50000 64837 ns/op | |
BenchmarkSelectRowsSimpleJoins 50 44406087 ns/op | |
BenchmarkSelectRowsPreparedJoins 50 43673779 ns/op | |
BenchmarkInt2Text 50000 65195 ns/op | |
BenchmarkInt2Binary 50000 68639 ns/op | |
BenchmarkInt4Text 50000 64926 ns/op | |
BenchmarkInt4Binary 50000 63369 ns/op | |
BenchmarkInt8Text 50000 68645 ns/op | |
BenchmarkInt8Binary 50000 60804 ns/op | |
BenchmarkFloat4Text 10000 113736 ns/op | |
BenchmarkFloat4Binary 50000 65938 ns/op | |
BenchmarkFloat8Text 10000 134462 ns/op | |
BenchmarkFloat8Binary 50000 67073 ns/op | |
BenchmarkBoolText 50000 62485 ns/op | |
BenchmarkBoolBinary 50000 60136 ns/op | |
BenchmarkTimestampTzText 10000 196233 ns/op | |
BenchmarkTimestampTzBinary 50000 68504 ns/op | |
BenchmarkConnPool 20000000 94.6 ns/op | |
BenchmarkQueryArgs 5000000 697 ns/op | |
ok github.com/jackc/pgx 83.760s | |
jack@edi:~/dev/go/src/github.com/jackc/pgx$ go version | |
go version go1.3 linux/amd64 | |
jack@edi:~/dev/go/src/github.com/jackc/pgx$ go test -test.bench=. | |
PASS | |
BenchmarkSelectRowSimpleNarrow 50000 69397 ns/op | |
BenchmarkSelectRowPreparedNarrow 50000 48512 ns/op | |
BenchmarkSelectRowsSimpleNarrow 10000 128274 ns/op | |
BenchmarkSelectRowsPreparedNarrow 50000 72710 ns/op | |
BenchmarkSelectValuePreparedNarrow 50000 71724 ns/op | |
BenchmarkSelectValueToPreparedNarrow 50000 59161 ns/op | |
BenchmarkSelectRowsSimpleJoins 50 44004066 ns/op | |
BenchmarkSelectRowsPreparedJoins 50 44136693 ns/op | |
BenchmarkInt2Text 50000 64869 ns/op | |
BenchmarkInt2Binary 50000 62422 ns/op | |
BenchmarkInt4Text 50000 63446 ns/op | |
BenchmarkInt4Binary 50000 61787 ns/op | |
BenchmarkInt8Text 50000 68053 ns/op | |
BenchmarkInt8Binary 50000 64487 ns/op | |
BenchmarkFloat4Text 10000 113111 ns/op | |
BenchmarkFloat4Binary 50000 61998 ns/op | |
BenchmarkFloat8Text 10000 125717 ns/op | |
BenchmarkFloat8Binary 50000 74392 ns/op | |
BenchmarkBoolText 50000 61939 ns/op | |
BenchmarkBoolBinary 50000 62269 ns/op | |
BenchmarkTimestampTzText 10000 189695 ns/op | |
BenchmarkTimestampTzBinary 50000 67437 ns/op | |
BenchmarkConnPool 20000000 76.5 ns/op | |
BenchmarkQueryArgs 2000000 874 ns/op | |
ok github.com/jackc/pgx 86.687s | |
jack@edi:~/dev/go/src/github.com/jackc/pgx$ go test -test.bench=. | |
PASS | |
BenchmarkSelectRowSimpleNarrow 50000 68519 ns/op | |
BenchmarkSelectRowPreparedNarrow 50000 41991 ns/op | |
BenchmarkSelectRowsSimpleNarrow 10000 127277 ns/op | |
BenchmarkSelectRowsPreparedNarrow 20000 81412 ns/op | |
BenchmarkSelectValuePreparedNarrow 50000 75235 ns/op | |
BenchmarkSelectValueToPreparedNarrow 50000 61556 ns/op | |
BenchmarkSelectRowsSimpleJoins 50 43513867 ns/op | |
BenchmarkSelectRowsPreparedJoins 50 43826503 ns/op | |
BenchmarkInt2Text 50000 65816 ns/op | |
BenchmarkInt2Binary 50000 62381 ns/op | |
BenchmarkInt4Text 50000 63402 ns/op | |
BenchmarkInt4Binary 50000 62712 ns/op | |
BenchmarkInt8Text 50000 54076 ns/op | |
BenchmarkInt8Binary 50000 45071 ns/op | |
BenchmarkFloat4Text 50000 75002 ns/op | |
BenchmarkFloat4Binary 50000 41423 ns/op | |
BenchmarkFloat8Text 10000 105376 ns/op | |
BenchmarkFloat8Binary 50000 43916 ns/op | |
BenchmarkBoolText 50000 41728 ns/op | |
BenchmarkBoolBinary 50000 42062 ns/op | |
BenchmarkTimestampTzText 10000 141651 ns/op | |
BenchmarkTimestampTzBinary 50000 48186 ns/op | |
BenchmarkConnPool 20000000 76.3 ns/op | |
BenchmarkQueryArgs 2000000 917 ns/op | |
ok github.com/jackc/pgx 79.100s |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment