go_db_benchmark results 7/16/2014 with go-pg

gistfile1.sh-session

# Run on Core i7 4770, 16GB RAM, SSD

jack@edi:~/dev/go/src/github.com/jackc/go_db_bench$ uname -a
Linux edi 3.13.0-32-generic #57-Ubuntu SMP Tue Jul 15 03:51:08 UTC 2014 x86_64 x86_64 x86_64 GNU/Linux
jack@edi:~/dev/go/src/github.com/jackc/go_db_bench$ GO_DB_BENCH_PG_HOST=/var/run/postgresql go test -test.bench=. -test.benchmem -test.benchtime=5s
testing: warning: no tests to run
PASS
BenchmarkPgxNativeSelectSingleValueUnprepared	  100000	     76628 ns/op	     349 B/op	      11 allocs/op
BenchmarkPgxStdlibSelectSingleValueUnprepared	  100000	     85550 ns/op	     672 B/op	      23 allocs/op
BenchmarkPgSelectSingleValueUnprepared	  200000	     56735 ns/op	     218 B/op	       9 allocs/op
BenchmarkPqSelectSingleValueUnprepared	  100000	     81065 ns/op	    1039 B/op	      29 allocs/op
BenchmarkPgxNativeSelectSingleValuePrepared	  500000	     26112 ns/op	     108 B/op	       4 allocs/op
BenchmarkPgxStdlibSelectSingleValuePrepared	  500000	     32811 ns/op	     517 B/op	      21 allocs/op
BenchmarkPgSelectSingleValuePrepared	  500000	     28656 ns/op	     118 B/op	       5 allocs/op
BenchmarkPqSelectSingleValuePrepared	  500000	     33811 ns/op	     663 B/op	      23 allocs/op
BenchmarkRawSelectSingleValuePrepared	  500000	     21093 ns/op	       0 B/op	       0 allocs/op
BenchmarkPgxNativeSelectSingleRowUnprepared	  100000	     98022 ns/op	     937 B/op	      21 allocs/op
BenchmarkPgxStdlibSelectSingleRowUnprepared	  100000	    104381 ns/op	    1701 B/op	      37 allocs/op
BenchmarkPgSelectSingleRowUnprepared	  200000	     76483 ns/op	     868 B/op	      26 allocs/op
BenchmarkPqSelectSingleRowUnprepared	  100000	    107336 ns/op	    1726 B/op	      42 allocs/op
BenchmarkPgxNativeSelectSingleRowPrepared	  500000	     32784 ns/op	     217 B/op	       5 allocs/op
BenchmarkPgxStdlibSelectSingleRowPrepared	  200000	     40526 ns/op	    1057 B/op	      26 allocs/op
BenchmarkPgSelectSingleRowPrepared	  200000	     43769 ns/op	     453 B/op	      14 allocs/op
BenchmarkPqSelectSingleRowPrepared	  200000	     47003 ns/op	    1083 B/op	      31 allocs/op
BenchmarkRawSelectSingleRowPrepared	  500000	     23313 ns/op	       0 B/op	       0 allocs/op
BenchmarkPgxNativeSelectMultipleRowsUnprepared	   50000	    199525 ns/op	   12074 B/op	      84 allocs/op
BenchmarkPgxStdlibSelectMultipleRowsUnprepared	   50000	    294514 ns/op	   18670 B/op	     243 allocs/op
BenchmarkPgSelectMultipleRowsUnprepared	   20000	    318464 ns/op	   11580 B/op	     339 allocs/op
BenchmarkPqSelectMultipleRowsUnprepared	   50000	    360249 ns/op	   19205 B/op	     322 allocs/op
BenchmarkPgxNativeSelectMultipleRowsPrepared	  100000	    128915 ns/op	   11363 B/op	      68 allocs/op
BenchmarkPgxStdlibSelectMultipleRowsPrepared	  100000	    150528 ns/op	   17992 B/op	     232 allocs/op
BenchmarkPgSelectMultipleRowsPrepared	   50000	    247019 ns/op	   11163 B/op	     326 allocs/op
BenchmarkPqSelectMultipleRowsPrepared	   50000	    235830 ns/op	   18565 B/op	     312 allocs/op
BenchmarkRawSelectMultipleRowsPrepared	  200000	     42297 ns/op	       0 B/op	       0 allocs/op
ok  	github.com/jackc/go_db_bench	348.466s