pgbench comparison of SSD and Raid-1 array

http://developer.postgresql.org/pgdocs/postgres/pgbench.html

SSD: 160GB INTEL SSDSA2MH160G1GN rev 045C8820

RAID-1: Perc6/E array 2 x 750GB ST3750640NS rev 3BKH + rev 3.BKE

Started by initializing empty PG database on testing volume (modified init script to change location used in startup)

Setup local "trust all" access to databases in pg_hba.conf

Then initialized "pgbench" database with scale factor 600.

psql -U postgres 

postgres=# CREATE DATABASE pgbench;
postgres=# \q

pgbench -i pgbench -U postgres -s 600

Then we run a sequence of two tests simulating 90 clients doing either 100 or 1000 transactions per client. Results below.

Test results for Raid-1

Command: pgbench -c 90 -t 100 -U postgres pgbench

Result: 105 TPS

starting vacuum...end.
transaction type: TPC-B (sort of)
scaling factor: 600
number of clients: 90
number of transactions per client: 100
number of transactions actually processed: 9000/9000
tps = 104.731589 (including connections establishing)
tps = 104.912433 (excluding connections establishing)

---

Command: pgbench -c 90 -t 1000 -U postgres pgbench

Result: 76 TPS

starting vacuum...end.
transaction type: TPC-B (sort of)
scaling factor: 600
number of clients: 90
number of transactions per client: 1000
number of transactions actually processed: 90000/90000
tps = 76.221414 (including connections establishing)
tps = 76.230974 (excluding connections establishing)

Test results for SSD

Command: pgbench -c 90 -t 100 -U postgres pgbench

Result: 1584 TPS

starting vacuum...end.
transaction type: TPC-B (sort of)
scaling factor: 600
number of clients: 90
number of transactions per client: 100
number of transactions actually processed: 9000/9000
tps = 1544.595033 (including connections establishing)
tps = 1584.951275 (excluding connections establishing)

---

Command: pgbench -c 90 -t 1000 -U postgres pgbench

Result: 1390 TPS

starting vacuum...end.
transaction type: TPC-B (sort of)
scaling factor: 600
number of clients: 90
number of transactions per client: 1000
number of transactions actually processed: 90000/90000
tps = 1387.355134 (including connections establishing)
tps = 1390.564068 (excluding connections establishing)

-- BenMeekhof - 06 May 2010