Re: prelimiary performance comparison pgsql vs mysql

Le mardi 15 mars 2005 à 12:26 +0000, Mark Rae a écrit :

> >> Clients          1     2     3     4     6     8    12    16    32    64   128
> >> ------------------------------------------------------------------------------
> >> mysql-4.1.1   1.00  1.41  1.34  1.16  0.93  1.03  1.01  1.00  0.94  0.86  0.80
> >> pg-7.4.1      0.65  1.27  1.90  2.48  2.45  2.50  2.48  2.51  2.49  2.39  2.38

> by the time 3 clients are running, postgres is getting through the
> queries 1.90/1.34=1.42 times faster

That is very interesting!!!

I have several webapps on my server each one opens several queries to
the database from _each_ JSP - often more than three... So the hunch
that I had all along was right: PostgreSQL is a much better back end for
Tomcat/JSP than MySQL.

Cheers
Tony