O'Reilly logo

PostgreSQL 9.0 High Performance by Gregory Smith

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required