On 30-Aug-05, at 14:32, Josh Berkus wrote:
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?
Hi Josh,
The config has been reviewed by NetApp. We do get rates higher then
80mb/s, but on average, that's what we get.
Do you have NetApp filers deployed ?
How many spindles do you have in your volume ?
On which OS are you running Postgres ?
Thanks,
Rémy
--
--Josh
Josh Berkus
Aglio Database Solutions
San Francisco
---------------------------(end of
broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster