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?"Received on Tue Feb 27 2007 - 21:13:09 UTC
This archive was generated by hypermail 2.4.0 : Wed May 19 2021 - 11:39:06 UTC