Date: Mon, 28 Jan 2008 10:24:10 -0800 From: Darcy Buskermolen <darcyb@commandprompt.com> To: freebsd-performance@freebsd.org Subject: Re: postgresql-performance using sysbench Message-ID: <200801281024.11571.darcyb@commandprompt.com> In-Reply-To: <fnl35p$hnj$1@ger.gmane.org> References: <b41c75520801280701x35e628dk90841b55cac77045@mail.gmail.com> <fnl35p$hnj$1@ger.gmane.org>
next in thread | previous in thread | raw e-mail | index | archive | help
On Monday 28 January 2008 09:25:13 Ivan Voras wrote: > 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(). You don;t need to patch postgresql for that, all you need to do is turn that off. update_process_title = off in postgresql.conf and then restart the daemon. > 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. -- Darcy Buskermolen Command Prompt, Inc. +1.503.667.4564 X 102 http://www.commandprompt.com/ PostgreSQL solutions since 1997
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?200801281024.11571.darcyb>