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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
