From: Alan Hodgson <ahodgson@simkin.ca>
To: pgsql-performance@postgresql.org
Subject: Re: amazon ec2
Date: Tue, 3 May 2011 13:09:51 -0700
Message-ID: <201105031309.52154.ahodgson@simkin.ca> (raw)
In-Reply-To: <F3B854F7-53C8-4895-99BF-EB64BD6E5B53@gmail.com>
References: <ADB48657-780F-4465-ABE6-752C2FB3AF48@gmail.com>
<201105031241.20348.ahodgson@simkin.ca>
<F3B854F7-53C8-4895-99BF-EB64BD6E5B53@gmail.com>
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: ahodgson@simkin.ca
Subject: Re: amazon ec2
In-Reply-To: <201105031309.52154.ahodgson@simkin.ca>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox