postgresql-performance using sysbench

[Ivan Voras]

Claus Guttesen wrote:

> Ubuntu 7.10:
> 
> grep "transactions:" sysbench-clients-24|sort
> transactions:                        10000  (2354.49 per sec.)
> transactions:                        10001  (2126.28 per sec.)
> transactions:                        10001  (2215.52 per sec.)
> transactions:                        10001  (2236.03 per sec.)
> 
> FreeBSD 7.0 stable as of Jan. 28'th:
> 
> grep "transactions:" sysbench-clients-24|sort
> transactions:                        10001  (1600.36 per sec.)
> transactions:                        10002  (1963.95 per sec.)
> transactions:                        10005  (1973.17 per sec.)
> 
> In other runs FreeBSD also seems to trail Ubuntu. Are there any knobs
> I could try on FreeBSD?

I think the excellent results Kris got with FreeBSD were significantly 
helped by patching postgresql to remove setproctitle(). Other than that, 
  from the sysbench line I see this is OLTP benchmark which should mean 
a lot of write transactions, and I've consistently seen much better file 
system write performance on Linux than on FreeBSD. No tuning can help here.


-------------- 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/20080128/da142ccb/signature.pgp