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:

l...@balapapa ~ $ pgbench -i -s 5                                               
                                                                           
...
l...@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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to