mkfs.xfs -d sunit=128 -d swidth=4096 -l size=128m -f /dev/sdb

mount -o rw,noatime,nousrquota,logbufs=8 /dev/sdb /mnt/ssd

Setup

• BEGIN;
• UPDATE accounts SET abalance = abalance + :delta WHERE aid = :aid;
• SELECT abalance FROM accounts WHERE aid = :aid;
• UPDATE tellers SET tbalance = tbalance + :delta WHERE tid = :tid;
• UPDATE branches SET bbalance = bbalance + :delta WHERE bid = :bid;
• INSERT INTO history (tid, bid, aid, delta, mtime) VALUES (:tid, :bid, :aid, :delta, CURRENT_TIMESTAMP);
• END;

CREATE TABLESPACE ssdbench LOCATION '/mnt/ssd/tablespace';
createdb -D ssdbench pgbench

pgbench -i -s 100 pgbench

pgbench -n -t 10000 -v -c 100 pgbench

transaction type: TPC-B (sort of)
scaling factor: 100
number of clients: 100
number of transactions per client: 10000
number of transactions actually processed: 1000000/1000000
tps = 1344.524649 (including connections establishing)
tps = 1344.802165 (excluding connections establishing)