20201111-results-master.txt

Master
------
 relkind |        relname        |   nrows   | blk_before | mb_before | blk_after | mb_after |  Diff
---------+-----------------------+-----------+------------+-----------+-----------+----------+-------
 r       | pgbench_accounts      | 200000000 |    3278689 |   25614.8 |   3314951 |  25898.1 | +1.1%
 i       | accounts_mtime        | 200000000 |     770080 |    6016.3 |    811946 |   6343.3 | +5.4%
 i       | pgbench_accounts_pkey | 200000000 |     548383 |    4284.2 |    548383 |   4284.2 |    0
 i       | tenner                | 200000000 |     230701 |    1802.4 |    252346 |   1971.5 | +9.4%
(4 rows)


scaling factor: 2000
query mode: simple
number of clients: 8
number of threads: 2
duration: 3600 s
number of transactions actually processed: 10888764
latency average = 2.645 ms
tps = 3024.655171 (including connections establishing)
tps = 3024.656457 (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.045  BEGIN;
         0.270  UPDATE pgbench_accounts SET abalance = abalance + :delta WHERE aid = :aid1;
         0.160  SELECT abalance FROM pgbench_accounts WHERE aid = :aid2;
         2.164  END;

scaling factor: 2000
query mode: simple
number of clients: 8
number of threads: 2
duration: 3600 s
number of transactions actually processed: 68662449
latency average = 0.419 ms
tps = 19072.900643 (including connections establishing)
tps = 19072.908953 (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.117  SELECT abalance FROM pgbench_accounts WHERE aid = :aid1;
         0.113  SELECT abalance FROM pgbench_accounts WHERE aid = :aid2;
         0.113  SELECT abalance FROM pgbench_accounts WHERE aid = :aid3;
         0.038  END;

scaling factor: 2000
query mode: simple
number of clients: 8
number of threads: 2
duration: 3600 s
number of transactions actually processed: 8731
latency average = 3306.752 ms
tps = 2.419293 (including connections establishing)
tps = 2.419294 (excluding connections establishing)
statement latencies in milliseconds:
      3306.620  SELECT abalance FROM pgbench_accounts WHERE mtime > now() - INTERVAL '15min' ORDER BY aid;