From owner-freebsd-current@FreeBSD.ORG Tue Feb 27 20:59:53 2007 Return-Path: X-Original-To: current@FreeBSD.org Delivered-To: freebsd-current@FreeBSD.ORG Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52]) by hub.freebsd.org (Postfix) with ESMTP id 7E5CD16A405; Tue, 27 Feb 2007 20:59:53 +0000 (UTC) (envelope-from kris@obsecurity.org) Received: from elvis.mu.org (elvis.mu.org [192.203.228.196]) by mx1.freebsd.org (Postfix) with ESMTP id 6C4A113C4A7; Tue, 27 Feb 2007 20:59:53 +0000 (UTC) (envelope-from kris@obsecurity.org) Received: from obsecurity.dyndns.org (elvis.mu.org [192.203.228.196]) by elvis.mu.org (Postfix) with ESMTP id 4F0B21A4D80; Tue, 27 Feb 2007 12:59:53 -0800 (PST) Received: by obsecurity.dyndns.org (Postfix, from userid 1000) id 7A36A5138A; Tue, 27 Feb 2007 15:59:52 -0500 (EST) Date: Tue, 27 Feb 2007 15:59:52 -0500 From: Kris Kennaway To: "Jim C. Nasby" Message-ID: <20070227205951.GA56651@xor.obsecurity.org> References: <20070224213111.GB41434@xor.obsecurity.org> <20070227182511.GD29041@decibel.org> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20070227182511.GD29041@decibel.org> User-Agent: Mutt/1.4.2.2i Cc: smp@FreeBSD.org, hackers@FreeBSD.org, current@FreeBSD.org, Kris Kennaway Subject: Re: Progress on scaling of FreeBSD on 8 CPU systems X-BeenThere: freebsd-current@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Discussions about the use of FreeBSD-current List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 27 Feb 2007 20:59:53 -0000 On Tue, Feb 27, 2007 at 12:25:11PM -0600, Jim C. Nasby wrote: > On Sat, Feb 24, 2007 at 04:31:11PM -0500, Kris Kennaway wrote: > > Now that the goals of the SMPng project are complete, for the past > > year or more several of us have been working hard on profiling FreeBSD > > in various multiprocessor workloads, and looking for performance > > bottlenecks to be optimized. > > > > We have recently made significant progress on optimizing for MySQL > > running on an 8-core amd64 system. The graph of results may be found > > here: > > I do *not* want to start a database war here, but I'm wondering if any > testing has been done with PostgreSQL? The reason I'm asking is that > there are some benchmarks that show MySQL falling off drastically with > increased concurrency: > > http://www.mysqlperformanceblog.com/2006/11/30/interesting-mysql-and-postgresql-benchmarks/ > > It would be interesting to see how the changes you've made stack up > using PostgreSQL as the benchmark. I've mentioned this a couple of times, but postgresql didn't scale well [on freebsd at least] when I tried it last year. I hope to revisit when I get time. Kris