From owner-freebsd-smp@FreeBSD.ORG Thu Mar 1 05:40:55 2007 Return-Path: X-Original-To: smp@freebsd.org Delivered-To: freebsd-smp@FreeBSD.ORG Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52]) by hub.freebsd.org (Postfix) with ESMTP id 0CB3416A403 for ; Thu, 1 Mar 2007 05:40:55 +0000 (UTC) (envelope-from netslists@gmail.com) Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.168]) by mx1.freebsd.org (Postfix) with ESMTP id 64E7313C4A3 for ; Thu, 1 Mar 2007 05:40:51 +0000 (UTC) (envelope-from netslists@gmail.com) Received: by ug-out-1314.google.com with SMTP id 71so290137ugh for ; Wed, 28 Feb 2007 21:40:51 -0800 (PST) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:user-agent:mime-version:to:cc:subject:references:in-reply-to:content-type:content-transfer-encoding; b=Gga+nURMcnWK/F6ONvWVmfVaQpkzHzcXm4xwk3at3s2yx1nEepRnxmPoe6jijicGsFYGiyNxmVlUr//czUuHldNK21hddvcT+T5a+qS//8+zfkLnmEPwFrzUsrsFWF6tVBvFnVKeeoJvuVfVoEcUD1+OtwFJFMEHI1/aHsh9Eb8= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:user-agent:mime-version:to:cc:subject:references:in-reply-to:content-type:content-transfer-encoding; b=KqKHa4524h58bRUpEub2Y9v9GcOORW+gZge8hDLJKAudm1auMows87qvlGePYvzUrOSpqwrN06VbxPiV5w4eahJgLjml65y4dkrD5lAqwuze6PPea4dJwSO5QxKMIXs5qOcJCSsRGlT1lzWtjpi9D5m6yxzIkVwDF9sHh+5L0TU= Received: by 10.67.119.13 with SMTP id w13mr1720222ugm.1172725976059; Wed, 28 Feb 2007 21:12:56 -0800 (PST) Received: from ?192.168.11.11? ( [85.164.1.86]) by mx.google.com with ESMTP id s1sm1151795uge.2007.02.28.21.12.54; Wed, 28 Feb 2007 21:12:55 -0800 (PST) Message-ID: <45E660CE.6010600@gmail.com> Date: Thu, 01 Mar 2007 06:12:46 +0100 From: Sten Daniel Soersdal User-Agent: Thunderbird 1.5.0.9 (Windows/20061207) MIME-Version: 1.0 To: "Jim C. Nasby" References: <20070224213111.GB41434@xor.obsecurity.org> <20070227182511.GD29041@decibel.org> <20070227205951.GA56651@xor.obsecurity.org> <20070227221252.GD51916@decibel.org> In-Reply-To: <20070227221252.GD51916@decibel.org> Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit 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-smp@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: FreeBSD SMP implementation group List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 01 Mar 2007 05:40:55 -0000 Jim C. Nasby wrote: > 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. Just a me 2 for postgresql tests: I would be interrested in postgresql numbers too as i have servers with 2 x dual core (xeon, dell 2850ies) currently running 6.1. I'm basically looking for something like a benchmark which would justify upgrading (or even experiment with 7.x) to my boss. I am aware that it's not your job to spend your valuable time doing obscure tests for us, so consider this rant as another "vote" for postgresql performance benchmarks. -- Sten Daniel Soersdal