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?