On Thursday 14. January 2010 14.31.07 Howard Cole wrote: > Test setup: pgbench -i -s 5 > Test run: pgbench -T 120 > > You may think this is a short test, but running it for much longer does > not seem to make a significant difference. > > Now running on windows I get ~ 700 TPS, but on linux I am getting ~70 TPS. > > The hardware configuration is Dual Opteron, 8GB Ram and 4 sata disks in > a Hardware Raid 10 configuration. For what it's worth, on my aging Gentoo Linux workstation with a Pentium 4 @ 3 GHz, 1 GB RAM and a single 400 GB SATA Seagate Barracuda disk, default Postgres 8.4.2 installation, I get: leif@balapapa ~ $ pgbench -i -s 5 ... leif@balapapa ~ $ pgbench -T 120 starting vacuum...end. transaction type: TPC-B (sort of) scaling factor: 5 query mode: simple number of clients: 1 duration: 120 s number of transactions actually processed: 29990 tps = 249.694058 (including connections establishing) tps = 249.700935 (excluding connections establishing) regards, -- Leif Biberg Kristensen http;//solumslekt.org/ -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
