From owner-freebsd-hackers@FreeBSD.ORG Mon Nov 5 21:30:35 2012 Return-Path: Delivered-To: freebsd-hackers@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52]) by hub.freebsd.org (Postfix) with ESMTP id 41396751 for ; Mon, 5 Nov 2012 21:30:35 +0000 (UTC) (envelope-from sfourman@gmail.com) Received: from mail-ee0-f54.google.com (mail-ee0-f54.google.com [74.125.83.54]) by mx1.freebsd.org (Postfix) with ESMTP id C42138FC17 for ; Mon, 5 Nov 2012 21:30:34 +0000 (UTC) Received: by mail-ee0-f54.google.com with SMTP id c50so4086372eek.13 for ; Mon, 05 Nov 2012 13:30:33 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type; bh=EYDcu3Ph5Hgz/+Myx0FocGqI7AV/BfiOcRordIFsmkQ=; b=DFnkv5939pHOoBxaQQAgSWfKq/clDjtUhy1+IoEkC0ltKaw44Ec6zJp6urvpZFQ6GP wpt2jjuQG5VAbIaxNvlfg7N7JQz45GK1W/4JsoQzleLUqJhEbssnmAZPPKM2mI4IEI6b DpFgWvQL0s4w8KkntzrnKDhYXeZhMAdlDrShnRbVv0XgEGPTxHQip6K0o1Qi2nnosXfZ s+DDoPrOi9jTKSkJziRq3aDticPgSw/FHz8AbmTP733p/TTdlzC9hFtSYv9K0Z7GZFSs TVquRted8DIpiT2XSNzrNZqBV0ULOzCHhkchtWL1GNbRO2TZFalm7XvWr1E+4V7096Yv jDuA== MIME-Version: 1.0 Received: by 10.14.172.137 with SMTP id t9mr41334012eel.2.1352151033495; Mon, 05 Nov 2012 13:30:33 -0800 (PST) Received: by 10.14.140.79 with HTTP; Mon, 5 Nov 2012 13:30:33 -0800 (PST) In-Reply-To: References: <50980ADD.4010402@rawbw.com> Date: Mon, 5 Nov 2012 15:30:33 -0600 Message-ID: Subject: Re: pgbench performance is lagging compared to Linux and DragonflyBSD? From: "Sam Fourman Jr." To: Garrett Cooper Content-Type: text/plain; charset=ISO-8859-1 Cc: Yuri , freebsd-hackers@freebsd.org X-BeenThere: freebsd-hackers@freebsd.org X-Mailman-Version: 2.1.14 Precedence: list List-Id: Technical Discussions relating to FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 05 Nov 2012 21:30:35 -0000 > The important item that has been left out (or is just implied as OS level > defaults) is sysctl/tunable variables set in the *BSD OSes (on DFly, > FreeBSD, and NetBSD). Unfortunately (based on my experience) FreeBSD could > be a lot better when it comes to defaults, and more tuning is required to > get better performance. So if they're working with the OS defaults, this > might not be a fair equivalent to the best performance that FreeBSD can > yield, but it's probably fair to do this for the sake of repeatability and > to prove what these OSes can do out of the box. This is in addition to the > [lock] contention issues that jeffr@ and a few others are working on > alleviating. > has someone wrote a howto for how to tune pgsql 9+ in FreeBSD? im mostly asking here to get information posted here for future reference, as google will pick this thread up and it will help others. -- Sam Fourman Jr.