Re: Amazon EC2 CPU Utilization

From: Jeff Davis <pgsql(at)j-davis(dot)com>
To: Mike Bresnahan <mike(dot)bresnahan(at)bestbuy(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Amazon EC2 CPU Utilization
Date: 2010-01-28 23:01:27
Message-ID: 1264719687.30389.69.camel@monkey-cat.sm.truviso.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-general

On Thu, 2010-01-28 at 22:45 +0000, Mike Bresnahan wrote:
> I can understand that I will not get as much performance out of a EC2 instance
> as a dedicated server, but I don't understand why top(1) is showing 50% CPU
> utilization.

One possible cause is lock contention, but I don't know if that explains
your problem. Perhaps there's something about the handling of shared
memory or semaphores on EC2 that makes it slow enough that it's causing
lock contention.

You could try testing on a xen instance and see if you have the same
problem.

Regards,
Jeff Davis

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Craig Ringer 2010-01-29 00:51:45 Re: emedded SQL in C to get the record type from plpgsql
Previous Message Mike Bresnahan 2010-01-28 22:45:45 Re: Amazon EC2 CPU Utilization

Browse pgsql-general by date

  From Date Subject
Next Message Vijay Sharma 2010-01-28 23:08:23 how to update a view from a table
Previous Message Mike Bresnahan 2010-01-28 22:45:45 Re: Amazon EC2 CPU Utilization