From owner-freebsd-performance@FreeBSD.ORG Wed Mar 19 22:25:07 2014 Return-Path: Delivered-To: freebsd-performance@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [8.8.178.115]) (using TLSv1 with cipher ADH-AES256-SHA (256/256 bits)) (No client certificate requested) by hub.freebsd.org (Postfix) with ESMTPS id 0BEE3FD3 for ; Wed, 19 Mar 2014 22:25:07 +0000 (UTC) Received: from mail-pd0-x233.google.com (mail-pd0-x233.google.com [IPv6:2607:f8b0:400e:c02::233]) (using TLSv1 with cipher ECDHE-RSA-RC4-SHA (128/128 bits)) (No client certificate requested) by mx1.freebsd.org (Postfix) with ESMTPS id D36AC77D for ; Wed, 19 Mar 2014 22:25:06 +0000 (UTC) Received: by mail-pd0-f179.google.com with SMTP id w10so9318559pde.10 for ; Wed, 19 Mar 2014 15:25:06 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=message-id:disposition-notification-to:date:from:user-agent :mime-version:to:subject:references:in-reply-to:content-type :content-transfer-encoding; bh=zGiZSZp2UU1GxaHrbmup78khIWGKjYhk/oTXALrPYVc=; b=fuCzQr4PVin2P0V176o29JeK/VijZ07PpXVTHmruRwSOsAmBYrt7UpCsMFDpUAk+ta R5BRAGJ51IFW4tI+0Nyn6TuFyy5022JBA0XroUXzKH1clXuH4XSm4Ut9o+bvVYuM8K6k h8CrHICZJYe0SD5YdO73KPEGIKZPrVqsCZTkEoFbuUGTHXHmVgtdHfNfDIbfr6cc92Rv eVd0iw7ZZmw2yoqseB53FXQC3ssoKSyHEqA8wXRRQQiW6nw5RWJ/QTunn8zXIA+1mOlF C9hWd256ahYyAtXcnzzsUkvTJzEolk+EV0wJIUB6B02xYOCevN4QB+hKtgbjayBfzUYL 5mCQ== X-Received: by 10.68.133.163 with SMTP id pd3mr6306992pbb.166.1395267906520; Wed, 19 Mar 2014 15:25:06 -0700 (PDT) Received: from [10.11.12.12] (203-206-165-226.perm.iinet.net.au. [203.206.165.226]) by mx.google.com with ESMTPSA id g6sm109795125pat.2.2014.03.19.15.25.04 for (version=TLSv1 cipher=ECDHE-RSA-RC4-SHA bits=128/128); Wed, 19 Mar 2014 15:25:05 -0700 (PDT) Message-ID: <532A192A.1070509@gmail.com> Date: Thu, 20 Mar 2014 09:24:42 +1100 From: Petr Janda User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:24.0) Gecko/20100101 Thunderbird/24.4.0 MIME-Version: 1.0 To: Steven Hartland , freebsd-performance@freebsd.org Subject: Re: FreeBSD 10 and PostgreSQL 9.3 scalability issues References: <5327B9B7.3050103@gmail.com> <2610F490C952470C9D15999550F67068@multiplay.co.uk> In-Reply-To: <2610F490C952470C9D15999550F67068@multiplay.co.uk> Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Mailman-Approved-At: Wed, 19 Mar 2014 22:33:39 +0000 X-BeenThere: freebsd-performance@freebsd.org X-Mailman-Version: 2.1.17 Precedence: list List-Id: Performance/tuning List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 19 Mar 2014 22:25:07 -0000 Hi, As far as I know, the test was done on both UFS2 and ZFS and the difference was marginal. Petr On 18/03/2014 10:47 PM, Steven Hartland wrote: > ----- Original Message ----- From: "Petr Janda" > > >> Hi guys, >> >> Just want to share these pgbench results done by DragonFlyBSD, and would >> like some input on why these numbers look so bad and what can be done to >> improve (ie. kernel tunables etc) the performance. >> >> http://lists.dragonflybsd.org/pipermail/users/attachments/20140310/4250b961/attachment-0001.pdf >> > > > Do you have the ability to test with FreeBSD 8.x and 9.x to see if this is > regression? > > Also you don't mention the FS used in each case, so I'm wondering if you > used a ZFS install of FreeBSD which could help to explain things. > > Regards > Steve