On 5/22/2013 8:18 AM, Greg Smith wrote:

They can easily hit that number.  Or they can do this:

Device: r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sdd     2702.80  19.40  19.67   0.16    14.91   273.68  71.74 0.37 100.00
sdd     2707.60  13.00  19.53   0.10    14.78   276.61  90.34 0.37 100.00

That's an Intel 710 being crushed by a random read database server workload, unable to deliver even 3000 IOPS / 20MB/s. I have hours of data like this from several servers.

This is interesting. Do you know what it is about the workload that leads to the unusually low rps ?





--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance

Reply via email to