John R Pierce <pierce <at> hogranch.com> writes:
> more likely, he's disk IO bound, but hard to say as that iostat output
> only showed a couple 2 second slices of work. the first output, which
> shows average since system startup, seems to show the system has had
> relatively high average wait times of 100ms on the average, yet the
> samples below only show 0, 2, 3mS await.
I don't think the problem is disk I/O. The database easily fits in the available
RAM (in fact there is a ton of RAM free) and iostat does not show a heavy load.