20201028-v5-results.txt

/* 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;