Boston Linux & Unix (BLU) Home | Calendar | Mail Lists | List Archives | Desktop SIG | Hardware Hacking SIG
Wiki | Flickr | PicasaWeb | Video | Maps & Directions | Installfests | Keysignings
Linux Cafe | Meeting Notes | Blog | Linux Links | Bling | About BLU

BLU Discuss list archive

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: PostgreSQL vs MySQL Throughdown! Teams?

 [hidden email] wrote: 
> It is beginning to sound like people have a few things to say about the 
> matter. There are lots of benchmarks out there and no one knows what to 
> trust, so here's my proposal. 
> We have a MySQL team and a PostgreSQL team. The two teams will develop a 
> single benchmark that will function exactly the same on both systems. 
> Something with a lot of concurrency and a balance between complex and 
> simple queries. 

It's already been done, sort of. 

On the SPECjAppServer2004 benchmark, a test of J2EE performance, a 
server running Postgres 8.2 scored 778 JOPS (jAppServer Operations Per 
Second), and a server running MySQL 5 scored 721 JOPS.  But the hardware 
isn't exactly comparable: the database server for Postgres was an 
eight-core Sun Fire T2000 with 16 GB of memory, while the database 
server for MySQL was a four-core Sun Fire X4100 with 8 GB of memory.

The TPC (Transaction Processing Council) also has a number of benchmarks 
for various aspects of database performance.  I can't find any official 
*recent* results from them for Postgres or MySQL, but this page has an 
interesting comparison of the results from various subtests of TCP-D, 
which measures query optimization:'s%20BLOG%20%5B136%5D/1132

There are lots of different things people use RDBMS's for, so you can't 
compose one benchmark and say it is *the* measurement for comparison. 

Here's an interesting essay by a PostgreSQL developer regarding the 
strengths and weaknesses of each platform:

This message has been scanned for viruses and 
dangerous content by MailScanner, and is 
believed to be clean. 

Discuss mailing list 
[hidden email]

BLU is a member of BostonUserGroups
BLU is a member of BostonUserGroups
We also thank MIT for the use of their facilities.

Valid HTML 4.01! Valid CSS!

Boston Linux & Unix /