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.
_______________________________________________
List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
Searchable Archive: http://www.grokbase.com/group/[email protected]
