From owner-freebsd-performance@FreeBSD.ORG Tue Mar 18 11:47:53 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 D6BFE109 for ; Tue, 18 Mar 2014 11:47:53 +0000 (UTC) Received: from smtp1.multiplay.co.uk (smtp1.multiplay.co.uk [85.236.96.35]) by mx1.freebsd.org (Postfix) with ESMTP id 9A51D2A4 for ; Tue, 18 Mar 2014 11:47:53 +0000 (UTC) Received: by smtp1.multiplay.co.uk (Postfix, from userid 65534) id 1F6FB20E7088A; Tue, 18 Mar 2014 11:47:52 +0000 (UTC) X-Spam-Checker-Version: SpamAssassin 3.3.1 (2010-03-16) on smtp1.multiplay.co.uk X-Spam-Level: ** X-Spam-Status: No, score=2.8 required=8.0 tests=AWL,BAYES_05,DOS_OE_TO_MX, FSL_HELO_NON_FQDN_1,HELO_NO_DOMAIN,RDNS_DYNAMIC,STOX_REPLY_TYPE autolearn=no version=3.3.1 Received: from r2d2 (82-69-141-170.dsl.in-addr.zen.co.uk [82.69.141.170]) by smtp1.multiplay.co.uk (Postfix) with ESMTPS id CBE3220E70886; Tue, 18 Mar 2014 11:47:47 +0000 (UTC) Message-ID: <2610F490C952470C9D15999550F67068@multiplay.co.uk> From: "Steven Hartland" To: "Petr Janda" , References: <5327B9B7.3050103@gmail.com> Subject: Re: FreeBSD 10 and PostgreSQL 9.3 scalability issues Date: Tue, 18 Mar 2014 11:47:43 -0000 MIME-Version: 1.0 Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.5931 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.6157 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: Tue, 18 Mar 2014 11:47:53 -0000 ----- 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