From owner-freebsd-hackers@FreeBSD.ORG Thu Feb 23 14:34:16 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 4A014106566C; Thu, 23 Feb 2012 14:34:16 +0000 (UTC) (envelope-from jhb@freebsd.org) Received: from cyrus.watson.org (cyrus.watson.org [65.122.17.42]) by mx1.freebsd.org (Postfix) with ESMTP id 1C8368FC0C; Thu, 23 Feb 2012 14:34:16 +0000 (UTC) Received: from bigwig.baldwin.cx (bigwig.baldwin.cx [96.47.65.170]) by cyrus.watson.org (Postfix) with ESMTPSA id C9AA846B0A; Thu, 23 Feb 2012 09:34:15 -0500 (EST) Received: from jhbbsd.localnet (unknown [209.249.190.124]) by bigwig.baldwin.cx (Postfix) with ESMTPSA id 406B5B94F; Thu, 23 Feb 2012 09:34:15 -0500 (EST) From: John Baldwin To: freebsd-hackers@freebsd.org Date: Thu, 23 Feb 2012 08:22:16 -0500 User-Agent: KMail/1.13.5 (FreeBSD/8.2-CBSD-20110714-p10; KDE/4.5.5; amd64; ; ) References: <4F45AB76.5050201@FreeBSD.org> In-Reply-To: <4F45AB76.5050201@FreeBSD.org> MIME-Version: 1.0 Content-Type: Text/Plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Message-Id: <201202230822.16304.jhb@freebsd.org> X-Greylist: Sender succeeded SMTP AUTH, not delayed by milter-greylist-4.2.7 (bigwig.baldwin.cx); Thu, 23 Feb 2012 09:34:15 -0500 (EST) Cc: "hackers@freebsd.org" , Doug Barton , 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: Thu, 23 Feb 2012 14:34:16 -0000 On Wednesday, February 22, 2012 9:59:02 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? It makes all your SYSV SHMs wired. That's fine if you are running a dedicated server using SYSV SHMs where you want that process to use all the RAM in the machine (e.g. a pgqsl server). It's not so great for a general purpose load where you would like an otherwise-idle process using SYSV SHMs to have the SHMs paged out to swap if other processes on the machine need memory and the box is under memory pressure. -- John Baldwin