> 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? You add more and faster disks. -- regards Claus When lenity and cruelty play for a kingdom, the gentler gamester is the soonest winner. Shakespeare -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
