On Thu, 2009-01-22 at 17:47 +0200, Ibrahim Harrani wrote: > Hi, > > I am running postgresql 8.3.5 on FreeBSD with Dual core Intel(R) > Xeon(R) CPU 3065 @ 2.33GHz, 2GB RAM and Seagate Technology - > Barracuda 7200.10 SATA 3.0Gb/ (RAID 1). > > I made several benchmark test with pgbench, TPS rate is almost 40 +/- 5. > $ pgbench -i pgbench -s 50 -U pgsql > > [pgsql@$ pgbench -c 200 -t 2 -U pgsql -d pgbench > > transaction type: TPC-B (sort of) > scaling factor: 10 > number of clients: 200 > number of transactions per client: 2 > number of transactions actually processed: 400/400 > tps = 39.044088 (including connections establishing) > tps = 41.528795 (excluding connections establishing) > > [pgsql@$ pgbench -c 100 -t 5 -U pgsql -d pgbench > > transaction type: TPC-B (sort of) > scaling factor: 10 > number of clients: 100 > number of transactions per client: 5 > number of transactions actually processed: 500/500 > tps = 30.162271 (including connections establishing) > tps = 30.643256 (excluding connections establishing) > > Is this rate is normal or not? What can I do to improve tps and insert > performance? Run a real benchmark. Running 400/500 transactions doesn't give you any real indication of what is going on. Run 50000 or so and see how it looks. Joshua D. Drake -- PostgreSQL - XMPP: jdrake@xxxxxxxxxxxxxxxxxxxxx Consulting, Development, Support, Training 503-667-4564 - http://www.commandprompt.com/ The PostgreSQL Company, serving since 1997 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
