| 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: | Whole Thread | Raw Message | 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
| 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 |