Transaction tests on SMP Linux

On Thu, Jan 03, 2002 at 11:17:04PM +0100, Fredrik Estreen wrote:
Fredrik:Not sure who or where this should go to, but here is what I did,hope it makes some sense.. The box normally
runsoracle, its notbusy at the moment.. I sent a copy to pgsql-hackers@postgresql.org,I think that is the correct
address.
 
For the SMP test (I think it was using pgbench)downloaded the 7.2b4 sourcebuild postgres from source into /usr/local
treemanuallystarted the db with defaults       build pgbench
 
hardware is a 2-processor Dell box, 1.2 GZ Zeon processors4G memory with RAID SCSI disksLinux seti 2.4.7-10smp #1 SMP
ThuSep 6 17:09:31 EDT 2001 i686 unknown
 
setup pgbench with : pgbench -i testdb -c 50 -t 40 -s 10changed postgresql.conf parameters    wal_files = 4           #
range0-64    shared_buffers = 200    # 2*max_connections, min 16test run as pgbench testdb -- output follows:
 

[kklatt@seti pgbench]$ pgbench testdb -c 50 -t 40 -s 10
starting vacuum...end.
transaction type: TPC-B (sort of)
scaling factor: 10
number of clients: 50
number of transactions per client: 40
number of transactions actually processed: 2000/2000
tps = 101.847384(including connections establishing)
tps = 104.345472(excluding connections establishing)

Hope this makes some sense..

Kenny Klatt
Data Architect / Oracle DBA
University of Wisconsin Milwaukee