Re: Amazon EC2 CPU Utilization

Mike Bresnahan <mike.bresnahan@bestbuy.com>

From: Mike Bresnahan <mike.bresnahan@bestbuy.com>
To: pgsql-general@postgresql.org
Date: 2010-01-27T23:15:45Z
Lists: pgsql-bugs, pgsql-general
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.