Re: postgresql-performance using sysbench
- From: Ivan Voras <ivoras@xxxxxxxxxxx>
- Date: Mon, 28 Jan 2008 18:25:13 +0100
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.
Attachment:
signature.asc
Description: OpenPGP digital signature
- Follow-Ups:
- Re: postgresql-performance using sysbench
- From: Darcy Buskermolen
- Re: postgresql-performance using sysbench
- References:
- postgresql-performance using sysbench
- From: Claus Guttesen
- postgresql-performance using sysbench
- Prev by Date: Re: PHP with open_basedir performance problem
- Next by Date: Re: postgresql-performance using sysbench
- Previous by thread: postgresql-performance using sysbench
- Next by thread: Re: postgresql-performance using sysbench
- Index(es):
Relevant Pages
|
|
