Re: Amazon High I/O instances

From: Vincent Veyron <vv(dot)lists(at)wanadoo(dot)fr>
To: Merlin Moncure <mmoncure(at)gmail(dot)com>
Cc: Sébastien Lorion <sl(at)thestrangefactory(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Amazon High I/O instances
Date: 2012-08-21 17:16:21
Message-ID: 1345569381.3438.49.camel@asus-1001PX.home
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Le mardi 21 août 2012 à 09:36 -0500, Merlin Moncure a écrit :

> here's a datapoint, stock config:
> pgbench -i -s 500
> pgbench -c 16 -T 60
> number of transactions actually processed: 418012
> tps = 6962.607292 (including connections establishing)
> tps = 6973.154593 (excluding connections establishing)
>
> not too shabby. this was run by a friend who is evaluating high i/o
> instances for their high load db servers. we didn't have time to
> kick off a high scale read only test unfortunately.
>
> Regarding 'AWS vs bare metal', I think high i/o instances full a huge
> niche in their lineup. Dollar for dollar, I'm coming around to the
> point of view that dealing with aws is a cheaper/more effective
> solution than renting out space from a data center or (even worse)
> running your own data center unless you're very large or have other
> special requirements. Historically the problem with AWS is that you
> had no solution for highly transaction bound systems which forced you
> to split your environment which ruined most of the benefit, and they
> fixed that.
>

Hi Merlin,

I am sure you can get good performance with these.

I simply focused on the part where seb said he was testing his app, and
since you can get some really high data throughput (by my very modest
standards anyway) with a good machine, I wondered why he did it.

Maybe seb is planning for an application that already has hundreds of
users after all, I did oversee that option.

To Sébastien : please use 'reply all' to send your reply to the list

Le mardi 21 août 2012 à 10:29 -0400, Sébastien Lorion a écrit :
Could you elaborate on the complexity you mention ? Setting up a machine
on Amazon, even with a script, is quite simple. As for the pricing you
give, it can be matched on Amazon using Micro or small instances, which
would be adequate given your load average.
>
>

Well, it _has_ to be more complicated to use AWS than a bare machine,
because of the added layer?

--
Vincent Veyron
http://vincentveyron.com/
Gestion informatique des sinistres d'assurances et des dossiers contentieux pour le service juridique

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sébastien Lorion 2012-08-21 18:25:34 Re: Amazon High I/O instances
Previous Message Merlin Moncure 2012-08-21 14:36:13 Re: Amazon High I/O instances