Re: postgresql vs mysql performance comparison - Mailing list pgsql-general

From J. Greenlees
Subject Re: postgresql vs mysql performance comparison
Date
Msg-id 422C9C3A.3040908@telus.net
Whole thread Raw
In response to postgresql vs mysql performance comparison  ("Rick Schumeyer" <rschumeyer@ieee.org>)
List pgsql-general
Rick Schumeyer wrote:
> 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.

mysql is finally getting to be closer in full capabilities to postgresql.

some of the newest data isn't yet tested, as they are just releasing a
version that can do what postgresql has done for a while.
free webcast on wednessday this week about it:

http://www.mysql.com/news-and-events/web-seminars/eds-goldengate-mysql.php

mysql has been optimised for speed of porcesses, not security and
enterprise class db apps.
postgresql has been more focusses on the later, as that is where the
real usage is.



Attachment

pgsql-general by date:

Previous
From: "Rick Schumeyer"
Date:
Subject: postgresql vs mysql performance comparison
Next
From: Scott Marlowe
Date:
Subject: Re: postgresql vs mysql performance comparison