From owner-freebsd-performance@FreeBSD.ORG Mon Jan 28 20:46:55 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 96C5116A417 for ; Mon, 28 Jan 2008 20:46:55 +0000 (UTC) (envelope-from kometen@gmail.com) Received: from an-out-0708.google.com (an-out-0708.google.com [209.85.132.248]) by mx1.freebsd.org (Postfix) with ESMTP id 48EB413C47E for ; Mon, 28 Jan 2008 20:46:55 +0000 (UTC) (envelope-from kometen@gmail.com) Received: by an-out-0708.google.com with SMTP id c14so482542anc.13 for ; Mon, 28 Jan 2008 12:46:54 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=QB60fgUhS8h5Gsz/VO0z9KtCPn8C2LEeAyPgZyu1WpU=; b=oCUhl2JK5GMffzTUY5zmHf8wqri9HUjLGDkgkEGsWAKbVf5B0u0s1Psnr738BLAqa+rjroZYt7NKDJw13BBi0rq5GAnLPCXxgtSz8A9fGrHYgr4L6ZKQ+c63cI7vnpXk+82HDTbPT3H7XK4euKARM3SJFniJvzeNXVknBot5clg= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=G/XpDKBtYk2LQGcNzdNkzrHu6l7TtbrDNkQbCBc82+OUkAT4uDKqqrvt4vxgbZn0yVZqis79iSm/jGmdgqAqY4320eerbKLJXSGeu5LzG4Kkf5vUd8RTTVXI6LWCdLmnDVeCg/0NpdbzHpDz8bjF67+o8V5C5561HVDkHGbwKqk= Received: by 10.100.216.3 with SMTP id o3mr12860833ang.86.1201553214468; Mon, 28 Jan 2008 12:46:54 -0800 (PST) Received: by 10.100.242.10 with HTTP; Mon, 28 Jan 2008 12:46:54 -0800 (PST) Message-ID: Date: Mon, 28 Jan 2008 21:46:54 +0100 From: "Claus Guttesen" To: "Kris Kennaway" In-Reply-To: <479E3C5E.1070405@FreeBSD.org> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <200801281024.11571.darcyb@commandprompt.com> <479E3C5E.1070405@FreeBSD.org> 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:46:55 -0000 > >>>> 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 wouldn't deploy zfs on a prod. db-server so this is just to hear if some had tried zfs (with compression enabled). > > 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. I had (allready) saved the thread in my mail-account so I could look it up before I started testing. :-) So I compiled postgresql with the option WITH_THREADSAFE=true and used sysbench with --pgsql-host="" . As pointed out by Ivan my test also involved r/w whereas the thread you (probably) mention at http://groups.google.com/group/mailing.freebsd.stable/browse_thread/thread/e224cd4f76e9ec2d is a read-only test. I forgot to mention in my first post that I'm using ULE. The p800 controller has a (factory set) 25/75 read/write cache ratio. -- regards Claus When lenity and cruelty play for a kingdom, the gentlest gamester is the soonest winner. Shakespeare