PostgreSQL vs. MySQL benchmarks on SMP FreeBSD 7.0 - Mailing list pgsql-general

From pobox@verysmall.org
Subject PostgreSQL vs. MySQL benchmarks on SMP FreeBSD 7.0
Date
Msg-id 47CEAAF9.4040906@verysmall.org
Whole thread Raw
Responses Re: PostgreSQL vs. MySQL benchmarks on SMP FreeBSD 7.0  (Greg Smith <gsmith@gregsmith.com>)
List pgsql-general
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


pgsql-general by date:

Previous
From: btober@ct.metrocast.net
Date:
Subject: Re: how do you write aggregate function
Next
From: Reece Hart
Date:
Subject: executing query results withing psql