From owner-freebsd-performance@FreeBSD.ORG Mon Jan 28 20:34:39 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 950E716A41B for ; Mon, 28 Jan 2008 20:34:39 +0000 (UTC) (envelope-from kris@FreeBSD.org) Received: from weak.local (freefall.freebsd.org [IPv6:2001:4f8:fff6::28]) by mx1.freebsd.org (Postfix) with ESMTP id 927A313C45B; Mon, 28 Jan 2008 20:34:38 +0000 (UTC) (envelope-from kris@FreeBSD.org) Message-ID: <479E3C5E.1070405@FreeBSD.org> Date: Mon, 28 Jan 2008 21:34:38 +0100 From: Kris Kennaway User-Agent: Thunderbird 2.0.0.9 (Macintosh/20071031) MIME-Version: 1.0 To: Claus Guttesen References: <200801281024.11571.darcyb@commandprompt.com> In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Cc: Darcy Buskermolen , freebsd-performance@freebsd.org 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 20:34:39 -0000 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. > > I found the setting and set it to off but no real difference in performance. > >>> 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. > > Yes, that is correct. I wanted to conduct a r/w test. But if it's down > to the fs itself I will just leave it atm. I will probably deploy the > server on FreeBSD anyway since we probably won't reach that many > writes in the foreseable future and FreeBSD is what I do best. > > Will zfs be able to achieve better performance? I guess that ufs2 will > remain more or less in the state it is in now. > I went through this in detail in a thread on -stable recently (Subject: Performance!). Rather than me going over all of this again, can you please read that thread in detail and get back to me once you have applied all of the discussion there to your case. Kris