Re: [9.4 CF] Free VMs for Reviewers & Testers

From: Daniel Farina <daniel(at)heroku(dot)com>
To: Craig Ringer <craig(at)2ndquadrant(dot)com>
Cc: Josh Berkus <josh(at)agliodbs(dot)com>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org>, pgsql-rrreviewers(at)postgresql(dot)org
Subject: Re: [9.4 CF] Free VMs for Reviewers & Testers
Date: 2013-07-09 05:49:26
Message-ID: CAAZKuFaX7uNfk9YPMnw6mjDmZHuyzL1x8yOtcjcy8rYNA5ppxg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-rrreviewers

On Mon, Jul 8, 2013 at 7:25 PM, Craig Ringer <craig(at)2ndquadrant(dot)com> wrote:
> On 07/09/2013 08:35 AM, Josh Berkus wrote:
>> Since these are cloud servers, they won't work well for performance
>> testing.
>
> I did some work on that a while ago, and found that I was able to get
> _astonishingly_ stable performance results out of EC2 EBS instances
> using provisioned IOPS volumes. Running them as "EBS Optimized" didn't
> seem to be required for the workloads I was testing on.

My colleague, Greg Burek, has done similar measurements and has
assessed an overall similar conclusion: the EBS PIOPS product delivers
exactly what it says on the tin...even under random access. They can
be striped with software-RAID.

> These VMs aren't well suited to vertical scaling performance tests and
> pushing extremes, but they're really, really good for "what impact does
> this patch have on regular real-world workloads".

The really, really big ones are useful even for pushing limits, such
as cr1.8xlarge, with 32 CPUs and 244GiB memory. Current spot instance
price (the heavily discounted "can die at any time" one) is $0.343/hr.
Otherwise, it's 3.500/hr.

Another instance offering that -- unlike the former -- I have yet to
experience in any way at all is the high-storage ones, also the
hs1.8xlarge, with 16CPU, 117GB RAM, and 24 instance-local rotational
media of 2TB apiece. This is enough to deliver sequential reads
measured in a couple of GB/s. I think this is a workhorse behind the
AWS Redshift data warehousing offering. I don't think this one has
spot pricing either: my guess is availability is low.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Hitoshi Harada 2013-07-09 06:00:16 Re: [PATCH] Add transforms feature
Previous Message Atri Sharma 2013-07-09 04:40:46 Re: Should we automatically run duplicate_oids?

Browse pgsql-rrreviewers by date

  From Date Subject
Next Message Jesper Krogh 2013-07-09 07:24:49 Re: [HACKERS] [9.4 CF] Free VMs for Reviewers & Testers
Previous Message Craig Ringer 2013-07-09 02:25:50 Re: [HACKERS] [9.4 CF] Free VMs for Reviewers & Testers