From owner-freebsd-hackers@FreeBSD.ORG Tue Feb 27 22:13:09 2007 Return-Path: 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 66D3716A402; Tue, 27 Feb 2007 22:13:09 +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 56C8913C474; Tue, 27 Feb 2007 22:13:03 +0000 (UTC) (envelope-from decibel@decibel.org) Received: by noel.decibel.org (Postfix, from userid 1001) id 825D156448; Tue, 27 Feb 2007 16:12:56 -0600 (CST) Received: (hashcash-sendmail, from uid 1001); Tue, 27 Feb 2007 16:12:52 -0600 Date: Tue, 27 Feb 2007 16:12:52 -0600 From: "Jim C. Nasby" To: Kris Kennaway Message-ID: <20070227221252.GD51916@decibel.org> References: <20070224213111.GB41434@xor.obsecurity.org> <20070227182511.GD29041@decibel.org> <20070227205951.GA56651@xor.obsecurity.org> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20070227205951.GA56651@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::wLOhjXd5ltJ5IpVt:000000000000000000 000000000000000000000000Eto9 X-Hashcash: 1:20:070227:smp@freebsd.org::9BQbC1VrW17/px+a:000cyW X-Hashcash: 1:20:070227:hackers@freebsd.org::l4G+UwZc9EVfZ30P:000000000000000000 0000000000000000000000000MVl X-Hashcash: 1:20:070227:current@freebsd.org::SAkcIpT47EVw7M9K:000000000000000000 0000000000000000000000004zQf 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 List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 27 Feb 2007 22:13:09 -0000 On Tue, Feb 27, 2007 at 03:59:52PM -0500, Kris Kennaway wrote: > 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. Let me know if you need help when you get to that point. Keep in mind that PostgreSQL's out-of-the-box configuration is pretty conservative, so you won't get good numbers that way. -- 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?"