Skip to content

Instantly share code, notes, and snippets.

@jackc
Created June 21, 2014 14:51
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save jackc/964001ba6e960d661acc to your computer and use it in GitHub Desktop.
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
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