Re: Amazon EC2 CPU Utilization

From: Mike Bresnahan <mike(dot)bresnahan(at)bestbuy(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Amazon EC2 CPU Utilization
Date: 2010-01-27 23:15:45
Message-ID: loom.20100128T001411-480@post.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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.

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Mason Hale 2010-01-27 23:23:12 unable to fail over to warm standby server
Previous Message John R Pierce 2010-01-27 22:55:06 Re: Amazon EC2 CPU Utilization

Browse pgsql-general by date

  From Date Subject
Next Message Mike Bresnahan 2010-01-27 23:29:09 Re: Amazon EC2 CPU Utilization
Previous Message John R Pierce 2010-01-27 22:55:06 Re: Amazon EC2 CPU Utilization