Re: amazon ec2 - Mailing list pgsql-performance

From Alan Hodgson
Subject Re: amazon ec2
Date
Msg-id 201105031309.52154.ahodgson@simkin.ca
Whole thread Raw
In response to Re: amazon ec2  (Joel Reymont <joelr1@gmail.com>)
Responses Re: amazon ec2
Re: amazon ec2
Re: amazon ec2
List pgsql-performance
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.

pgsql-performance by date:

Previous
From: Joel Reymont
Date:
Subject: Re: amazon ec2
Next
From: Greg Spiegelberg
Date:
Subject: Re: amazon ec2