20201114-results-master.txt

scaling factor: 3000
query mode: simple
number of clients: 8
number of threads: 2
duration: 28800 s
number of transactions actually processed: 69500073
latency average = 3.315 ms
tps = 2413.196788 (including connections establishing)
tps = 2413.196914 (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.275  UPDATE pgbench_accounts SET abalance = abalance + :delta WHERE aid = :aid1;
         0.146  SELECT abalance FROM pgbench_accounts WHERE aid = :aid2;
         2.846  END;

scaling factor: 3000
query mode: simple
number of clients: 8
number of threads: 2
duration: 28800 s
number of transactions actually processed: 568423448
latency average = 0.405 ms
tps = 19736.925054 (including connections establishing)
tps = 19736.926125 (excluding connections establishing)
statement latencies in milliseconds:
         0.001  \set aid1 random_gaussian(1, 100000 * :scale, 2.0)
         0.000  \set aid2 random_gaussian(1, 100000 * :scale, 2.5)
         0.001  \set aid3 random_gaussian(1, 100000 * :scale, 3.2)
         0.032  BEGIN;
         0.113  SELECT abalance FROM pgbench_accounts WHERE aid = :aid1;
         0.110  SELECT abalance FROM pgbench_accounts WHERE aid = :aid2;
         0.108  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: 21258
latency average = 10838.799 ms
tps = 0.738089 (including connections establishing)
tps = 0.738089 (excluding connections establishing)
statement latencies in milliseconds:
     10838.685  SELECT abalance FROM pgbench_accounts WHERE mtime > now() - INTERVAL '15min' ORDER BY aid;