Just looking into High IO instances for a DB deployment. In order to get past 1TB, we are looking at RAID-0. I have heard (http://hackerne.ws/item?id=4266119) there might be a problem if TRIM isn't supported. Does anyone know if it is and has anyone used RAID-0 on these instances? (Linux of course…)
On Aug 21, 2012, at 9:36 AM, Merlin Moncure wrote: > On Tue, Aug 21, 2012 at 12:33 AM, Sébastien Lorion > <s...@thestrangefactory.com> wrote: >> Hello, >> >> Since Amazon has added new high I/O instance types and EBS volumes, anyone >> has done some benchmark of PostgreSQL on them ? >> >> http://perspectives.mvdirona.com/2012/07/20/IOPerformanceNoLongerSucksInTheCloud.aspx >> http://perspectives.mvdirona.com/2012/08/01/EBSProvisionedIOPSOptimizedInstanceTypes.aspx >> http://aws.typepad.com/aws/2012/08/fast-forward-provisioned-iops-ebs.html >> >> I will be testing my app soon, but was curious to know if others have done >> some tests so I can compare / have a rough idea to what to expect. Looking >> on Google, I found an article about MySQL >> (http://palominodb.com/blog/2012/07/24/palomino-evaluates-amazon%E2%80%99s-new-high-io-ssd-instances), >> but nothing about PostgresSQL. > > 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. > > merlin
