From owner-freebsd-performance@FreeBSD.ORG Mon Jan 28 18:47:20 2008 Return-Path: Delivered-To: freebsd-performance@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 197A316A421 for ; Mon, 28 Jan 2008 18:47:20 +0000 (UTC) (envelope-from darcyb@commandprompt.com) Received: from lists.commandprompt.com (host-159.commandprompt.net [207.173.203.159]) by mx1.freebsd.org (Postfix) with ESMTP id ED52513C4FB for ; Mon, 28 Jan 2008 18:47:19 +0000 (UTC) (envelope-from darcyb@commandprompt.com) Received: from dbitech.homenet.dbitech.bc.ca (S010600a08330057a.ok.shawcable.net [24.67.72.171]) (authenticated bits=0) by lists.commandprompt.com (8.13.8/8.13.8) with ESMTP id m0SIObOH009862 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO) for ; Mon, 28 Jan 2008 10:24:39 -0800 From: Darcy Buskermolen Organization: Command Prompt To: freebsd-performance@freebsd.org Date: Mon, 28 Jan 2008 10:24:10 -0800 User-Agent: KMail/1.9.7 References: In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200801281024.11571.darcyb@commandprompt.com> X-Greylist: Sender succeeded SMTP AUTH, not delayed by milter-greylist-4.0 (lists.commandprompt.com [207.173.203.159]); Mon, 28 Jan 2008 10:24:39 -0800 (PST) X-Mailman-Approved-At: Mon, 28 Jan 2008 19:32:26 +0000 Subject: Re: postgresql-performance using sysbench X-BeenThere: freebsd-performance@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Performance/tuning List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 28 Jan 2008 18:47:20 -0000 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