Slide 12
Slide 12 text
pgbench 結果(参考)
● Aurora PostgreSQL 12.4 互換版
number of transactions actually processed: 300924
latency average = 9.970 ms
tps = 1003.051684 (including connections establishing)
tps = 1003.127591 (excluding connections establishing)
statement latencies in milliseconds:
0.001 \set aid random(1, 100000 * :scale)
0.000 \set bid random(1, 1 * :scale)
0.000 \set tid random(1, 10 * :scale)
0.000 \set delta random(-5000, 5000)
0.359 BEGIN;
2.119 UPDATE pgbench_accounts SET abalance = abalance + :delta WHERE aid = :aid;
1.417 SELECT abalance FROM pgbench_accounts WHERE aid = :aid;
1.039 INSERT INTO pgbench_history (tid, bid, aid, delta, mtime) VALUES (:tid, :bid, :aid, :delta, CURRENT_TIMESTAMP);
5.035 END;
12