Обсуждение: PostgreSQL vs. MySQL benchmarks on SMP FreeBSD 7.0

Apologizes if this has already been announced -

http://www.scribd.com/doc/551889/Introducing-Freebsd-70

a presentation of the SMP in FreeBSD 7.0 using PostgreSQL and MySQL to
produce benchmarks.

Notable quotes -

a) MySQL degrades after utilizing all CPUs, while PostgreSQL does not
(the explanation is that MySQL has scalability problem).

b) PostgreSQL is in general 35%-45% faster.

I can't tell if all is true, just wanted to make it public, if it hasn't
been already made.

Iv

On Wed, 5 Mar 2008, pobox@verysmall.org wrote:

> b) PostgreSQL is in general 35%-45% faster.

And this is using sysbench, which is an old MySQL benchmark with
rudimentary PostgreSQL support bolted on.  Last time I checked it didn't
even put statements into transaction blocks correctly under PostgreSQL
when you used the write tests (because the MySQL it was written for can't
do that at all).  The FreeBSD tests only run the read tests which avoid
that, but still it's clearly not a benchmark optimized for good PostgreSQL
performance.  I suspect if the sysbench schema/queries were ported to
pgbench the gap would widen considerably.

--
* Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD