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;