Ibrahim Harrani escribió: > I made several benchmark test with pgbench, TPS rate is almost 40 +/- 5. > $ pgbench -i pgbench -s 50 -U pgsql > > [pg...@$ pgbench -c 200 -t 2 -U pgsql -d pgbench
Try with 1000 transactions per client or more, instead of 2. Also, I think you should set the "scale" in the prepare step (-i) at least as high as the number of clients you're going to use. (I dimly recall some recent development in this area that might mean I'm wrong.) -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
