/usr/lib/postgresql/8.3/bin/pgbench -h node1 -p 5432 -c 16 -t 16 -S test1 -U test1 transaction type: TPC-B (sort of) scaling factor: 1 number of clients: 16 number of transactions per client: 16 number of transactions actually processed: 256/256 tps = 93.284398 (including connections establishing) tps = 132.452318 (excluding connections establishing) /usr/lib/postgresql/8.3/bin/pgbench -h node1 -p 5432 -c 16 -t 16 -S test1 -U test1 transaction type: SELECT only scaling factor: 1 number of clients: 16 number of transactions per client: 16 number of transactions actually processed: 256/256 tps = 283.113183 (including connections establishing) tps = 2298.644159 (excluding connections establishing) /usr/lib/postgresql/8.3/bin/pgbench -h node2 -p 5432 -c 16 -t 16 -S test1 -U test1 transaction type: TPC-B (sort of) scaling factor: 1 number of clients: 16 number of transactions per client: 16 number of transactions actually processed: 256/256 tps = 97.497216 (including connections establishing) tps = 138.449100 (excluding connections establishing) /usr/lib/postgresql/8.3/bin/pgbench -h node2 -p 5432 -c 16 -t 16 -S test1 -U test1 transaction type: SELECT only scaling factor: 1 number of clients: 16 number of transactions per client: 16 number of transactions actually processed: 256/256 tps = 294.388902 (including connections establishing) tps = 3130.541119 (excluding connections establishing) /usr/lib/postgresql/8.3/bin/pgbench -h slb -p 5432 -c 16 -t 16 -S test1 -U test1 transaction type: TPC-B (sort of) scaling factor: 1 number of clients: 16 number of transactions per client: 16 number of transactions actually processed: 256/256 tps = 96.601878 (including connections establishing) tps = 137.750830 (excluding connections establishing) /usr/lib/postgresql/8.3/bin/pgbench -h slb -p 5432 -c 16 -t 16 -S test1 -U test1 transaction type: SELECT only scaling factor: 1 number of clients: 16 number of transactions per client: 16 number of transactions actually processed: 256/256 tps = 308.444884 (including connections establishing) tps = 4369.644625 (excluding connections establishing) /usr/lib/postgresql/8.3/bin/pgbench -h ref -p 5432 -c 16 -t 16 -S test1 -U test1 transaction type: TPC-B (sort of) scaling factor: 1 number of clients: 16 number of transactions per client: 16 number of transactions actually processed: 256/256 tps = 527.557676 (including connections establishing) tps = 637.831373 (excluding connections establishing) /usr/lib/postgresql/8.3/bin/pgbench -h ref -p 5432 -c 16 -t 16 -S test1 -U test1 transaction type: SELECT only scaling factor: 1 number of clients: 16 number of transactions per client: 16 number of transactions actually processed: 256/256 tps = 1566.908844 (including connections establishing) tps = 3257.619139 (excluding connections establishing)