postgresql-performance using sysbench

[Ivan Voras]

Niki Denev wrote:

> HZ=1000
> Time:
>         239 seconds total
>         122 seconds of transactions (4 per second)

> What do you think?

This is a very low result :) I don't know your machine or the parameters 
you used with postmark but even FreeBSD on two striped 7.5 kRPM drives 
can achieve ~~ 110 tps (so ~~ 50 for a single drive). In the same 
circumstances and with the right file system - reiserfs in this case - 
Linux can achieve close to 900 tps (170 tps with ext3). This is the kind 
of difference I am talking about. A change of 4 tps to 6 tps is not 
generally useful.




-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 250 bytes
Desc: OpenPGP digital signature
Url : http://lists.freebsd.org/pipermail/freebsd-performance/attachments/20080131/00ff251c/signature.pgp