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.