Tom Lane wrote:
Hm, notice that the processor utilization doesn't actually drop all that
much, so it seems it's not fundamentally an "I/O storm" kind of issue.
If I read the chart on the bottom of Josh's links correctly,
it looks to me like
the fast one is spending >50% CPU in "user" and <30% CPU in "wait"
the slow one seems to spend ~40% in "user" and almost 40% in "wait"
Wouldn't that suggest the ratio of new order tpm (1320/1779) is
pretty well explained by the corresponding less "user" cpu time (40/50)
that in turn was caused by the increased io wait time? Or am I reading
that wrong?
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
