20201110-results-master.txt

Master
------
 dbname | nspname | relkind |        relname        |   nrows   | nblocks |   mb
--------+---------+---------+-----------------------+-----------+---------+---------
 bench  | public  | r       | pgbench_accounts      | 100000000 | 1639345 | 12807.4
        |         | i       | accounts_mtime        | 100000000 |  385042 |  3008.1
        |         | i       | pgbench_accounts_pkey | 100000000 |  274194 |  2142.1
        |         | i       | tenner                | 100000000 |  115352 |   901.2
(4 rows)
 dbname | nspname | relkind |        relname        |   nrows   | nblocks |   mb
--------+---------+---------+-----------------------+-----------+---------+---------
 bench  | public  | r       | pgbench_accounts      |  99995400 | 1677861 | 13182.8
        |         | i       | accounts_mtime        |  99995400 |  424413 |  3565.6
        |         | i       | pgbench_accounts_pkey |  99995400 |  274194 |  2142.3
        |         | i       | tenner                |  99995400 |  128513 |  1402.9
(4 rows)


scaling factor: 1000
query mode: simple
number of clients: 8
number of threads: 2
duration: 3600 s
number of transactions actually processed: 18543141
latency average = 1.553 ms
tps = 5150.839541 (including connections establishing)
tps = 5150.842233 (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.046  BEGIN;
         0.171  UPDATE pgbench_accounts SET abalance = abalance + :delta WHERE aid = :aid1;
         0.106  SELECT abalance FROM pgbench_accounts WHERE aid = :aid2;
         1.222  END;


scaling factor: 1000
query mode: simple
number of clients: 8
number of threads: 2
duration: 3600 s
number of transactions actually processed: 83279844
latency average = 0.346 ms
tps = 23133.287719 (including connections establishing)
tps = 23133.300225 (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.035  BEGIN;
         0.092  SELECT abalance FROM pgbench_accounts WHERE aid = :aid1;
         0.088  SELECT abalance FROM pgbench_accounts WHERE aid = :aid2;
         0.088  SELECT abalance FROM pgbench_accounts WHERE aid = :aid3;
         0.039  END;


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