root@stafford:/a/pgdata# /usr/local/sysbench/bin/sysbench --num-threads=32 --test=oltp --db-driver=postgres --pgsql-host=db12.pmtpa.wmnet --oltp-table-size=1000000 --db-ps-mode=auto --oltp-read-only=1 --oltp-test-mode=simple --max-requests=100000 --oltp-dist-type=uniform run sysbench 0.4.12: multi-threaded system evaluation benchmark Running the test with following options: Number of threads: 32 Doing OLTP test. Running simple OLTP test Using Uniform distribution Using "BEGIN" for starting transactions Using auto_inc on the id column Maximum number of requests for OLTP test is limited to 100000 Threads started! Done. OLTP test statistics: queries performed: read: 100119 write: 0 other: 0 total: 100119 transactions: 100119 (52711.76 per sec.) deadlocks: 0 (0.00 per sec.) read/write requests: 100119 (52711.76 per sec.) other operations: 0 (0.00 per sec.) Test execution summary: total time: 1.8994s total number of events: 100119 total time taken by event execution: 60.5853 per-request statistics: min: 0.15ms avg: 0.61ms max: 201.80ms approx. 95 percentile: 1.98ms Threads fairness: events (avg/stddev): 3128.7188/156.85 execution time (avg/stddev): 1.8933/0.00 root@stafford:/a/pgdata# /usr/local/sysbench/bin/sysbench --num-threads=32 --test=oltp --db-driver=postgres --pgsql-host=db20.pmtpa.wmnet --oltp-table-size=1000000 --db-ps-mode=auto --oltp-read-only=1 --oltp-test-mode=simple --max-requests=100000 --oltp-dist-type=uniform run sysbench 0.4.12: multi-threaded system evaluation benchmark Running the test with following options: Number of threads: 32 Doing OLTP test. Running simple OLTP test Using Uniform distribution Using "BEGIN" for starting transactions Using auto_inc on the id column Maximum number of requests for OLTP test is limited to 100000 Threads started! Done. OLTP test statistics: queries performed: read: 100122 write: 0 other: 0 total: 100122 transactions: 100122 (43927.74 per sec.) deadlocks: 0 (0.00 per sec.) read/write requests: 100122 (43927.74 per sec.) other operations: 0 (0.00 per sec.) Test execution summary: total time: 2.2792s total number of events: 100122 total time taken by event execution: 72.7546 per-request statistics: min: 0.19ms avg: 0.73ms max: 205.88ms approx. 95 percentile: 1.71ms Threads fairness: events (avg/stddev): 3128.8125/229.40 execution time (avg/stddev): 2.2736/0.00