--- Ivan Voras <[EMAIL PROTECTED]> wrote:
> Hi,
>
> Has anyone been able to replicate results from
>
http://www.kaltenbrunner.cc/blog/index.php?/archives/21-guid.html,
> or
> get close to the performance described there on
> similar hardware (e.g.
> thousands of transactions/s) ?
>
Here's mine for a somewhat similar setup.
FreeBSD 7.0 PostgreSQL 8.3
2x Intel Xeon 2.33GHZ quad cores (8 cores total), 8GB
RAM, 250GB RAID 10 (4x WD Raptor 10K drives).
Non-default settings:
max_connections = 200
shared_buffers = 1900MB
wal_buffers = 1024kB
checkpoint_segments = 192
checkpoint_timeout = 30min
createdb testdb
pgbench -i -s 100 testdb
# pgbench -c 100 -t 100000 testdb
starting vacuum...end.
transaction type: TPC-B (sort of)
scaling factor: 100
number of clients: 100
number of transactions per client: 100000
number of transactions actually processed:
10000000/10000000
tps = 1650.806584 (including connections establishing)
tps = 1650.905036 (excluding connections establishing)
So, not as high as his numbers but then I've got less
RAM, one less drive spindle in my array (2 vs. 3 in
performance for the raid 10 setup), SATA vs. SCSI,
he's got 512MB of controller cache vs my 128MB.
--Alan
____________________________________________________________________________________
Be a better friend, newshound, and
know-it-all with Yahoo! Mobile. Try it now.
http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ
_______________________________________________
freebsd-performance@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-performance
To unsubscribe, send any mail to "[EMAIL PROTECTED]"
