postgresql vs mysql performance comparison

From: "Rick Schumeyer" <rschumeyer(at)ieee(dot)org>
To: "'PgSql General'" <pgsql-general(at)postgresql(dot)org>
Subject: postgresql vs mysql performance comparison
Date: 2005-03-07 18:00:36
Message-ID: 005101c5233f$90c15bb0$0200a8c0@dell8200
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'm interested in comparing the performance of postgresql and mysql

on various combinations of user loads and database sizes. I have seen

a few statements to the effect of "mysql is faster for small, low use

applications, but postgresql is better for bigger stuff". I would like

to run some independent tests to see if this is true.

Before I do this, has anyone done this already, with the latest

versions of both? I think I've seen some comparisons that are

somewhat dated.

Does anyone have any pointers on what to do or not do? Or

would anyone be willing to comment on an experiment plan

and suggest improvements? Any help or references are appreciated.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message J. Greenlees 2005-03-07 18:23:54 Re: postgresql vs mysql performance comparison
Previous Message Lonni J Friedman 2005-03-07 17:54:04 Re: Restoring db objects , help needed