Re: PostgreSQL vs. MySQL

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>
To: "Brian Tarbox" <btarbox@theworld.com>
Cc: "Rafal Kedziorski" <rafcio@polonium.de>, pgsql-performance@postgresql.org
Date: 2003-07-04T13:59:13Z
Lists: pgsql-hackers, pgsql-performance
"Brian Tarbox" <btarbox@theworld.com> writes:
> I recently took a system from MySQL to Postgres.  Same HW, SW, same data.
> The major operations where moderately complex queries (joins on 8 tables).

> The results we got was that Postgres was fully 3 times slower than MySql.
> We were on this  list a fair bit looking for answers and tried all the
> standard answers.  It was still much  much much slower.

Could we see the details?  It's not very fair to not give us a chance to
learn about problems.

			regards, tom lane