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