Le 2012-09-12 à 17:08, Sébastien Lorion a écrit :
> As you can see, I am nowhere near the results John mentioned for a 10,000 scale (about 8000 tps) and I am not sure
why.My instance setup and configuration should be ok, but I am far from an expert (a startup founder has to wear many
hats...),I simply followed advice found in Greg Smith book and what I read on the net. So, if anyone can offer insight
asto why the performance is not as good as expected, please let me know ..
>
> I did not terminate the AMI yet, so I can do more testing and/or try suggestions to improve the results. I will also
tryto run the benchmarks again on a pure RAID1 configuration with fsync off, which I will use for read-only databases.
I wonder if work_mem is too high? That's 1 GB per connection (max), but still a lot of RAM. Might want to try with more
reasonablevalues, such as 16MB to 64MB.
What are the iostat / vmstat numbers during the test?
Bye,
François