Fwd: Re: [Dbix-class] any factual comparisons of Oracle, PostgreSQL, MySQL ?

Matija Grabnar matija at serverflow.com
Thu Apr 14 18:32:21 GMT 2011


On 04/14/2011 07:39 PM, Peter Edwards wrote:
>
> PostgreSQL's speed increased dramatically between pg 7.3 (used here 
> two years ago) and pg 9.0 (used now).
>
> Some real world data
>
> http://www.jpab.org/Hibernate/PostgreSQL/server/Hibernate/MySQL/server.html
>
In the article you quoted, for almost every table of measurements they 
have a case where MySQL is slower, and a case where Postgresql is slower 
(in some cases, more than 100 times slower). Postgresql is never faster 
by such a large factor.

Which is why I said that if you care about speed, you should RUN TESTS, 
doing operations you will be doing on the kind of data you will be 
working with, and not rely on posts by fans of one side or the other.



More information about the DBIx-Class mailing list