From owner-freebsd-hackers@FreeBSD.ORG Thu Mar 1 15:19:49 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 5670316A400 for ; Thu, 1 Mar 2007 15:19:49 +0000 (UTC) (envelope-from zombyfork@gmail.com) Received: from wr-out-0506.google.com (wr-out-0506.google.com [64.233.184.227]) by mx1.freebsd.org (Postfix) with ESMTP id 03AF913C4A5 for ; Thu, 1 Mar 2007 15:19:48 +0000 (UTC) (envelope-from zombyfork@gmail.com) Received: by wr-out-0506.google.com with SMTP id 55so668769wri for ; Thu, 01 Mar 2007 07:19:48 -0800 (PST) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:references; b=HT5GzjRpJqLTOcKLG61s6nelMg52ONi/HKn6VKa0TtPvLxMHQORd7bKSt+n4HOJEwYLv3PY6eVediLhpOYWZ8zDzESvW1gyapjAUdMZe144LM6kYpu70HpVPOxsYWIel8yNPc80yPoV52hWIquOudd24OEaJ/70WiBc8YHT+ZsQ= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:references; b=A8kfAyOYLatDVMcPGAdVmlOkWmwLK3W3IX+AWbcQLGmEedXMYEFU5cEfTS52mYpTmN3Gkh//3If/IUn5//jyRRLRkjuysU2902NkGTncpWuhLHMBAYYogFXLZHu0BgyKjw7Xqdr7Tq4va8VcgAV6XEfhDraxNX6AUJFM8wxQ8XA= Received: by 10.114.157.1 with SMTP id f1mr179214wae.1172762387197; Thu, 01 Mar 2007 07:19:47 -0800 (PST) Received: by 10.115.108.15 with HTTP; Thu, 1 Mar 2007 07:19:46 -0800 (PST) Message-ID: <346a80220703010719k5fcd8d31l94b4dcef3f830a60@mail.gmail.com> Date: Thu, 1 Mar 2007 08:19:46 -0700 From: "Coleman Kane" To: "Sten Daniel Soersdal" In-Reply-To: <45E660CE.6010600@gmail.com> MIME-Version: 1.0 References: <20070224213111.GB41434@xor.obsecurity.org> <20070227182511.GD29041@decibel.org> <20070227205951.GA56651@xor.obsecurity.org> <20070227221252.GD51916@decibel.org> <45E660CE.6010600@gmail.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Content-Filtered-By: Mailman/MimeDel 2.1.5 Cc: Kris Kennaway , smp@freebsd.org, hackers@freebsd.org, current@freebsd.org, "Jim C. Nasby" 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 Reply-To: cokane@cokane.org List-Id: Technical Discussions relating to FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 01 Mar 2007 15:19:49 -0000 On 2/28/07, Sten Daniel Soersdal wrote: > > 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 I wouldn't recommend upgrading your production servers to FreeBSD 7.x yet, no matter what the results say. -- Coleman