Re: Progress on scaling of FreeBSD on 8 CPU systems

On 2/28/07, Sten Daniel Soersdal <netslists_at_gmail.com> 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