phoronix did some benchmarks of the ec2 machines and they show pretty poor
numbers, especially in the I/O side of things
http://www.phoronix.com/scan.php?page=article&item=amazon_ec2_round1&num=1
http://www.phoronix.com/scan.php?page=article&item=amazon_ec2_micro&num=1
David Lang
On Tue, 3 May 2011, Alan Hodgson wrote:
> Date: Tue, 3 May 2011 13:09:51 -0700
> From: Alan Hodgson <ahodgson@simkin.ca>
> To: pgsql-performance@postgresql.org
> Subject: Re: [PERFORM] amazon ec2
>
> On May 3, 2011 12:43:13 pm you wrote:
>> On May 3, 2011, at 8:41 PM, Alan Hodgson wrote:
>>> I am also interested in tips for this. EBS seems to suck pretty bad.
>>
>> Alan, can you elaborate? Are you using PG on top of EBS?
>>
>
> Trying to, yes.
>
> Let's see ...
>
> EBS volumes seem to vary in speed. Some are relatively fast. Some are really
> slow. Some fast ones become slow randomly. Some are fast attached to one
> instance, but really slow attached to another.
>
> Fast being a relative term, though. The fast ones seem to be able to do maybe
> 400 random IOPS. And of course you can only get about 80MB/sec sequential
> access to them on a good day.
>
> Which is why I'm interested in how other people are doing it. So far EC2
> doesn't seem well suited to running databases at all.
>
>