From owner-freebsd-performance@FreeBSD.ORG Mon Jan 28 20:21:03 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 D77EC16A420 for ; Mon, 28 Jan 2008 20:21:03 +0000 (UTC) (envelope-from kometen@gmail.com) Received: from an-out-0708.google.com (an-out-0708.google.com [209.85.132.250]) by mx1.freebsd.org (Postfix) with ESMTP id 9080B13C461 for ; Mon, 28 Jan 2008 20:21:03 +0000 (UTC) (envelope-from kometen@gmail.com) Received: by an-out-0708.google.com with SMTP id c14so479618anc.13 for ; Mon, 28 Jan 2008 12:21:03 -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=LZXgiIrAm5Z28RHM8oVkGrbq/be7Nz6M6tOaReufpeQ=; b=hjrxA67HB2JPpySlgOs4ev3IXwmZU954wbXuUK5T5mdQe7QsZFlwxBvJ529lEpJ6nNk//tXxhLKdaLMcll82brKCwnTGUa5E3psz3jvZEmPBzAqmR95VUI6oFJa8x41J69MoyYcH+fAfpb1BM9N6n4RwDSSwSbyUrTvPC/KJn9U= 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=pv/8g8FjWShGzEh8dxm0SvgkNGGEGuXCsi+lCOY3AEf8H4JUsZe9ksLjvhU58vygjAZLBdMQYKqOmTKxtozMjLvX2PCUM8f+VI5GRqvr2i8w3aCc9SFvidKmfFkedOUQldzaZwb5pZal90wHCRQnRf53nUTkw77P+HPD/VqiCDQ= Received: by 10.100.123.4 with SMTP id v4mr12900878anc.14.1201551663033; Mon, 28 Jan 2008 12:21:03 -0800 (PST) Received: by 10.100.242.10 with HTTP; Mon, 28 Jan 2008 12:21:03 -0800 (PST) Message-ID: Date: Mon, 28 Jan 2008 21:21:03 +0100 From: "Claus Guttesen" To: "Darcy Buskermolen" In-Reply-To: <200801281024.11571.darcyb@commandprompt.com> 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> Cc: 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:21:03 -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. -- regards Claus When lenity and cruelty play for a kingdom, the gentlest gamester is the soonest winner. Shakespeare