Re: Configuration Optimisation

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(at)balapapa ~ $ pgbench -i -s 5
...
leif(at)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/