From owner-freebsd-hackers@FreeBSD.ORG  Tue Feb 27 18:47:04 2007
Return-Path: <owner-freebsd-hackers@FreeBSD.ORG>
X-Original-To: hackers@FreeBSD.org
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 3CC3B16A403;
	Tue, 27 Feb 2007 18:47:04 +0000 (UTC)
	(envelope-from decibel@decibel.org)
Received: from noel.decibel.org (noel.decibel.org [67.100.216.10])
	by mx1.freebsd.org (Postfix) with ESMTP id 64E4313C428;
	Tue, 27 Feb 2007 18:47:02 +0000 (UTC)
	(envelope-from decibel@decibel.org)
Received: by noel.decibel.org (Postfix, from userid 1001)
	id 9370B56447; Tue, 27 Feb 2007 12:25:16 -0600 (CST)
Received: (hashcash-sendmail, from uid 1001); Tue, 27 Feb 2007 12:25:11 -0600
Date: Tue, 27 Feb 2007 12:25:11 -0600
From: "Jim C. Nasby" <decibel@decibel.org>
To: Kris Kennaway <kris@obsecurity.org>
Message-ID: <20070227182511.GD29041@decibel.org>
References: <20070224213111.GB41434@xor.obsecurity.org>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <20070224213111.GB41434@xor.obsecurity.org>
X-Operating-System: FreeBSD 6.1-RELEASE-p10 amd64
X-Distributed: Join the Effort!  http://www.distributed.net
User-Agent: Mutt/1.5.13 (2006-08-11)
X-Hashcash: 1:20:070227:kris@obsecurity.org::ZfkkrvGoPB4j26Q4:000000000000000000
	000000000000000000000000E4u8
X-Hashcash: 1:20:070227:current@freebsd.org::wLCCNtNwCp/MnJAC:000000000000000000
	0000000000000000000000005FBg
X-Hashcash: 1:20:070227:smp@freebsd.org::sNfaJBt1kI+uy+Kj:004bSG
X-Hashcash: 1:20:070227:hackers@freebsd.org::CCH717eLUGNxpKNB:000000000000000000
	0000000000000000000000002R0f
X-Mailman-Approved-At: Tue, 27 Feb 2007 20:41:15 +0000
Cc: smp@FreeBSD.org, hackers@FreeBSD.org, current@FreeBSD.org
Subject: Re: Progress on scaling of FreeBSD on 8 CPU systems
X-BeenThere: freebsd-hackers@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: Technical Discussions relating to FreeBSD
	<freebsd-hackers.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-hackers>, 
	<mailto:freebsd-hackers-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-hackers>
List-Post: <mailto:freebsd-hackers@freebsd.org>
List-Help: <mailto:freebsd-hackers-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-hackers>,
	<mailto:freebsd-hackers-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Tue, 27 Feb 2007 18:47:04 -0000

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.
-- 
Jim C. Nasby, Database Architect                decibel@decibel.org 
Give your computer some brain candy! www.distributed.net Team #1828

Windows: "Where do you want to go today?"
Linux: "Where do you want to go tomorrow?"
FreeBSD: "Are you guys coming, or what?"