From owner-freebsd-hackers@FreeBSD.ORG Tue Mar 27 14:24:35 2012 Return-Path: Delivered-To: hackers@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 8DF361065675 for ; Tue, 27 Mar 2012 14:24:35 +0000 (UTC) (envelope-from sjg@evilcode.net) Received: from mail-iy0-f182.google.com (mail-iy0-f182.google.com [209.85.210.182]) by mx1.freebsd.org (Postfix) with ESMTP id F08D68FC15 for ; Tue, 27 Mar 2012 14:24:34 +0000 (UTC) Received: by iahk25 with SMTP id k25so12962197iah.13 for ; Tue, 27 Mar 2012 07:24:34 -0700 (PDT) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=20120113; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type:x-gm-message-state; bh=1iI3xvLtftBhzjpP4HINzv38vJ7/aB+g4EAuv8xAe+k=; b=GwXep/HHL/xq6WByPg+tjsx+2fOXs/cX5zs0MSCPjbUMZNQQP6bezHpCS0zRMhGxwm 1KoEf17C1Rh3evAhUm1mXnLwDWlPB2VpG7c4T6YlBcZXLVQ2MEDoxzFnK7B7ZOYyUnYm mzlezapisUGfYpJqM48wJHIkmu8V8xgFvX5OFy692DQUHJpVrGHLduRxXmtv4Cd4dY8+ yKOPclrYbnQMShnX66yRurMpgRmPheGkKjxiV6BjGOG4TYveUJL+ORDG2JBS+Qualw38 iEiVTU9b9nmfJZWXEdhsQs4eFubCno0Qs5mtMMb9sYyAyNEVWU2p8A/KUYwnyDkU1KJy J4zw== MIME-Version: 1.0 Received: by 10.42.97.200 with SMTP id p8mr13010149icn.2.1332858272876; Tue, 27 Mar 2012 07:24:32 -0700 (PDT) Received: by 10.50.73.38 with HTTP; Tue, 27 Mar 2012 07:24:32 -0700 (PDT) In-Reply-To: <4F45AB76.5050201@FreeBSD.org> References: <4F45AB76.5050201@FreeBSD.org> Date: Tue, 27 Mar 2012 08:24:32 -0600 Message-ID: From: "Samuel J. Greear" To: Doug Barton X-Gm-Message-State: ALoCoQlSEb1iz7M9vNXgs3SfeBTiYGwEySOuNl9KRSQCZ/l/vEIGcRWSe0imxO5eZyqqmVxFIaWd X-Mailman-Approved-At: Tue, 27 Mar 2012 15:59:59 +0000 Content-Type: text/plain; charset=ISO-8859-1 X-Content-Filtered-By: Mailman/MimeDel 2.1.5 Cc: "hackers@freebsd.org" , Ivan Voras Subject: Re: PostgreSQL benchmarks (now with Linux numbers) X-BeenThere: freebsd-hackers@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Technical Discussions relating to FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 27 Mar 2012 14:24:35 -0000 On Wed, Feb 22, 2012 at 7:59 PM, Doug Barton wrote: > On 02/22/2012 01:42, Ivan Voras wrote: > > The Dragonfly team has recently liberated their VM from the giant lock > and there are some interesting benchmarks comparing it to FreeBSD 9 and a > derivative of RedHat Enterprise Linux: > > > > http://leaf.dragonflybsd.org/mailarchive/kernel/2011-11/msg00008.html > > > > Other developments are described in their release notes: > http://www.dragonflybsd.org/release30/ > > The 4.5 times improvement by enabling kern.ipc.shm_use_phys is pretty > notable, what prevents us from enabling that by default? > > > Doug > > -- I just saw this, so I thought I would mention -- DragonFly was not doing a great job allocating pv entries rapidly, which is needed during PostgreSQL warm up -- This made shm_use_phys appear very effective. It only makes 1-2% difference now on DragonFly, and only 1-2% difference on FreeBSD. Sam