PostgreSQL 9.0 High Performance

Sample disk results

Here's a summary of what was measured for the laptop drive tested in detail previously, as well as a desktop drive both alone and in a RAID array as a second useful data point:

Disks	Seq Read	Seq Write	bonnie++ seeks	sysbench seeks	Commits per sec
Seagate 320GB 7200.4 Laptop	71	58	232 @ 4GB	194 @ 4GB	105 or 1048
WD160GB 7200RPM	59	54	177 @ 16GB	56 @ 100GB	10212
3X WD160GB RAID0	125	119	371 @ 16GB	60 @ 100GB	10855

Note how all the seek-related information is reported here relative to the size of the area being used to seek over. This is a good habit to adopt. Also note that in the laptop rate, two commit rates are reported. The lower value is without the write cache enabled (just under the rotation rate ...