Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id E92CB133798E for ; Tue, 3 May 2011 17:10:02 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 81191-06 for ; Tue, 3 May 2011 20:09:54 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from zeus.simkin.ca (zeus.simkin.ca [72.51.27.124]) by mail.postgresql.org (Postfix) with ESMTP id 469091337BE4 for ; Tue, 3 May 2011 17:09:53 -0300 (ADT) Received: from pc-1072.reinvent.com (office.reinvent.com [72.51.27.254]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by zeus.simkin.ca (Postfix) with ESMTPSA id 0F1B227005E for ; Tue, 3 May 2011 13:09:52 -0700 (PDT) From: Alan Hodgson Organization: Simkin Network Consulting To: pgsql-performance@postgresql.org Subject: Re: amazon ec2 Date: Tue, 3 May 2011 13:09:51 -0700 User-Agent: KMail/1.13.5 (Linux/2.6.35-28-generic; KDE/4.5.1; x86_64; ; ) References: <201105031241.20348.ahodgson@simkin.ca> In-Reply-To: MIME-Version: 1.0 Content-Type: Text/Plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Message-Id: <201105031309.52154.ahodgson@simkin.ca> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.91 tagged_above=-10 required=5 tests=BAYES_00=-1.9, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201105/31 X-Sequence-Number: 43540 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.