Progress on scaling of FreeBSD on 8 CPU systems
Jim C. Nasby
decibel at decibel.org
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:
> > 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 at 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?"
More information about the freebsd-smp