Re: Progress on scaling of FreeBSD on 8 CPU systems



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.

Kris
_______________________________________________
freebsd-hackers@xxxxxxxxxxx mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-hackers
To unsubscribe, send any mail to "freebsd-hackers-unsubscribe@xxxxxxxxxxx"



Relevant Pages

  • Re: Progress on scaling of FreeBSD on 8 CPU systems
    ... year or more several of us have been working hard on profiling FreeBSD ... We have recently made significant progress on optimizing for MySQL ... testing has been done with PostgreSQL? ... there are some benchmarks that show MySQL falling off drastically with ...
    (freebsd-current)
  • Re: Progress on scaling of FreeBSD on 8 CPU systems
    ... year or more several of us have been working hard on profiling FreeBSD ... We have recently made significant progress on optimizing for MySQL ... testing has been done with PostgreSQL? ... there are some benchmarks that show MySQL falling off drastically with ...
    (freebsd-current)
  • Re: Progress on scaling of FreeBSD on 8 CPU systems
    ... year or more several of us have been working hard on profiling FreeBSD ... We have recently made significant progress on optimizing for MySQL ... testing has been done with PostgreSQL? ... there are some benchmarks that show MySQL falling off drastically with ...
    (freebsd-hackers)
  • Re: Progress on scaling of FreeBSD on 8 CPU systems
    ... year or more several of us have been working hard on profiling FreeBSD ... testing has been done with PostgreSQL? ... Just a me 2 for postgresql tests: ... rant as another "vote" for postgresql performance benchmarks. ...
    (freebsd-current)
  • Re: Progress on scaling of FreeBSD on 8 CPU systems
    ... year or more several of us have been working hard on profiling FreeBSD ... testing has been done with PostgreSQL? ... Just a me 2 for postgresql tests: ... rant as another "vote" for postgresql performance benchmarks. ...
    (freebsd-hackers)