Progress on scaling of FreeBSD on 8 CPU systems

Jim C. Nasby decibel at
Tue Feb 27 22:13:09 UTC 2007

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:
> > 
> >
> > 
> > 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 at 
Give your computer some brain candy! 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?"

More information about the freebsd-smp mailing list