[prev in list] [next in list] [prev in thread] [next in thread] 

List:       freebsd-hackers
Subject:    Re: Progress on scaling of FreeBSD on 8 CPU systems
From:       "Jim C. Nasby" <decibel () decibel ! org>
Date:       2007-02-27 22:12:52
Message-ID: 20070227221252.GD51916 () decibel ! org
[Download RAW message or body]

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?"
_______________________________________________
freebsd-hackers@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-hackers
To unsubscribe, send any mail to "freebsd-hackers-unsubscribe@freebsd.org"
[prev in list] [next in list] [prev in thread] [next in thread]