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 as to 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 try to 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 reasonable values, such as 16MB to 64MB. What are the iostat / vmstat numbers during the test? Bye, François -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
