/* master, conf1, -c32 -j8 -T 3600 // 11:37-12:38 */ transaction type: testcase.pgbench scaling factor: 10000 query mode: simple number of clients: 32 number of threads: 8 duration: 3600 s number of transactions actually processed: 6989491 latency average = 16.482 ms tps = 1941.512095 (including connections establishing) tps = 1941.513487 (excluding connections establishing) statement latencies in milliseconds: 0.002 \set aid1 random_gaussian(1, 100000 * :scale, 2.0) 0.001 \set aid2 random_gaussian(1, 100000 * :scale, 2.5) 0.001 \set aid3 random_gaussian(1, 100000 * :scale, 2.2) 0.000 \set bid random(1, 1 * :scale) 0.000 \set tid random(1, 10 * :scale) 0.000 \set delta random(-5000, 5000) 0.043 BEGIN; 4.476 UPDATE pgbench_accounts SET abalance = abalance + :delta WHERE aid = :aid1; 2.084 SELECT abalance FROM pgbench_accounts WHERE aid = :aid2; 2.090 SELECT abalance FROM pgbench_accounts WHERE aid = :aid3; 7.794 END; /* v5, conf1, -c32 -j8 -T 3600 // 15:06-16:07 */ transaction type: testcase.pgbench scaling factor: 10000 query mode: simple number of clients: 32 number of threads: 8 duration: 3600 s number of transactions actually processed: 9209274 latency average = 12.509 ms tps = 2558.117717 (including connections establishing) tps = 2558.119453 (excluding connections establishing) statement latencies in milliseconds: 0.001 \set aid1 random_gaussian(1, 100000 * :scale, 2.0) 0.001 \set aid2 random_gaussian(1, 100000 * :scale, 2.5) 0.001 \set aid3 random_gaussian(1, 100000 * :scale, 2.2) 0.000 \set bid random(1, 1 * :scale) 0.000 \set tid random(1, 10 * :scale) 0.000 \set delta random(-5000, 5000) 0.044 BEGIN; 2.009 UPDATE pgbench_accounts SET abalance = abalance + :delta WHERE aid = :aid1; 0.868 SELECT abalance FROM pgbench_accounts WHERE aid = :aid2; 0.893 SELECT abalance FROM pgbench_accounts WHERE aid = :aid3; 8.699 END; /* v5-restricted, conf1, -c32 -j8 -T 3600 // 18:07-19:08 */ transaction type: testcase.pgbench scaling factor: 10000 query mode: simple number of clients: 32 number of threads: 8 duration: 3600 s number of transactions actually processed: 9336856 latency average = 12.338 ms tps = 2593.517543 (including connections establishing) tps = 2593.519240 (excluding connections establishing) statement latencies in milliseconds: 0.001 \set aid1 random_gaussian(1, 100000 * :scale, 2.0) 0.001 \set aid2 random_gaussian(1, 100000 * :scale, 2.5) 0.001 \set aid3 random_gaussian(1, 100000 * :scale, 2.2) 0.000 \set bid random(1, 1 * :scale) 0.000 \set tid random(1, 10 * :scale) 0.000 \set delta random(-5000, 5000) 0.044 BEGIN; 1.955 UPDATE pgbench_accounts SET abalance = abalance + :delta WHERE aid = :aid1; 0.846 SELECT abalance FROM pgbench_accounts WHERE aid = :aid2; 0.866 SELECT abalance FROM pgbench_accounts WHERE aid = :aid3; 8.633 END;