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.