View Single Post
Old 26th December 2013
hanzer's Avatar
hanzer hanzer is offline
Real Name: Adam Jensen
just passing through
 
Join Date: Oct 2013
Location: EST USA
Posts: 314
Default

The test results with six 146GB 10kRPM U320 SCSI disks in a RAID5 array (with HP Smart Array 6404 RAID controller):

Code:
| initialize DB     | set scaling factor: 70  |
|-------------------+-------------------------|
| pgbench -i bench1 | pgbench -i -s 70 bench1 |


| Test         | command                            |
|--------------+------------------------------------|
| Read-Write   | pgbench -c 4 -j 2 -T 600 bench1    |
| Read-Only    | pgbench -c 4 -j 2 -T 600 -S bench1 |
| Simple Write | pgbench -c 4 -j 2 -T 600 -N bench1 |

Number of transactions processed:

| OS / Partition    | Read-Write | Read-Only | Simple Write |
|-------------------+------------+-----------+--------------|
| FreeBSD uncrypted |     207699 |   3037812 |       233599 |
| FreeBSD encrypted |     138485 |   2816533 |       201539 |
| OpenBSD uncrypted |      91896 |    135979 |        94823 |
| OpenBSD encrypted |      72809 |    137021 |        76443 |
bonnie++ file-system characterizations.

64GB partitions were used for all tests. Default configurations for Postgresql, softraid-crypto, and geli were used (basic recipes from the handbook or FAQ).

Conclusion: I think there might be something wrong with OpenBSD's ciss(4) driver.
Reply With Quote