pgbench_cockroach.txt

gistfile1.txt

[17:34:59] ~/code/go/src/github.com/cockroachdb/cockroach $ rm -rf cockroach-data

[17:35:02] ~/code/go/src/github.com/cockroachdb/cockroach $ ./cockroach start --background
CockroachDB node starting at 2017-01-05 17:35:11.062768945 +0000 UTC
build:      85fe10a @ 2017/01/05 17:34:36 (go1.7.1)
admin:      http://localhost:8080
sql:        postgresql://root@localhost:26257?sslmode=disable
logs:       cockroach-data/logs
store[0]:   path=cockroach-data
status:     initialized new cluster
clusterID:  ac6178ba-79cd-4f33-a062-740a377e563f
nodeID:     1

[17:35:11] ~/code/go/src/github.com/cockroachdb/cockroach $ go build ./pkg/sql/pgbench/cmd/pgbenchsetup

[17:35:19] ~/code/go/src/github.com/cockroachdb/cockroach $ ./pgbenchsetup -createdb postgresql://root@localhost:26257/test?sslmode=disable
Inserted 1 branch records
Inserted 10 teller records
Inserted 5000 account records
Inserted 5000 account records
Inserted 5000 account records
Inserted 5000 account records
Inserted 5000 account records
Inserted 5000 account records
Inserted 5000 account records
Inserted 5000 account records
Inserted 5000 account records
Inserted 5000 account records
Inserted 5000 account records
Inserted 5000 account records
Inserted 5000 account records
Inserted 5000 account records
Inserted 5000 account records
Inserted 5000 account records
Inserted 5000 account records
Inserted 5000 account records
Inserted 5000 account records
Inserted 5000 account records
Inserted 10 history records

[17:35:49] ~/code/go/src/github.com/cockroachdb/cockroach $ pgbench -h localhost -p 26257 -U root -n test
transaction type: TPC-B (sort of)
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
number of transactions per client: 10
number of transactions actually processed: 10/10
latency average: 0.000 ms
tps = 288.867063 (including connections establishing)
tps = 297.220984 (excluding connections establishing)