PostgreSQL 10 High Performance - Third Edition

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 RAID 0	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 ...