20201114-results-patched.txt

scaling factor: 3000
query mode: simple
number of clients: 8
number of threads: 2
duration: 28800 s
number of transactions actually processed: 71221374
latency average = 3.235 ms
tps = 2472.964179 (including connections establishing)
tps = 2472.964309 (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.000  \set delta random(-5000, 5000)
         0.044  BEGIN;
         0.280  UPDATE pgbench_accounts SET abalance = abalance + :delta WHERE aid = :aid1;
         0.149  SELECT abalance FROM pgbench_accounts WHERE aid = :aid2;
         2.758  END;
scaling factor: 3000
query mode: simple
number of clients: 8
number of threads: 2
duration: 28800 s
number of transactions actually processed: 562888005
latency average = 0.409 ms
tps = 19544.722130 (including connections establishing)
tps = 19544.723213 (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, 3.2)
         0.033  BEGIN;
         0.115  SELECT abalance FROM pgbench_accounts WHERE aid = :aid1;
         0.111  SELECT abalance FROM pgbench_accounts WHERE aid = :aid2;
         0.109  SELECT abalance FROM pgbench_accounts WHERE aid = :aid3;
         0.037  END;
scaling factor: 3000
query mode: simple
number of clients: 8
number of threads: 2
duration: 28800 s
number of transactions actually processed: 29715
latency average = 7754.629 ms
tps = 1.031642 (including connections establishing)
tps = 1.031642 (excluding connections establishing)
statement latencies in milliseconds:
      7754.543  SELECT abalance FROM pgbench_accounts WHERE mtime > now() - INTERVAL '15min' ORDER BY aid;