Remy,
> The behavior we see is that when running queries that do random reads
> on disk, IOWAIT goes over 80% and actual disk IO falls to a crawl at a
> throughput bellow 3000kB/s (We usually average 40000 kB/s to 80000 kB/s
> on sequential read operations on the netapps)
This seems pretty low for a NetApp -- you should be able to manage up to
180mb/s, if not higher. Are you sure it's configured correctly?
--
--Josh
Josh Berkus
Aglio Database Solutions
San Francisco