Horton

Re: PostgreSQL vs. MySQL

Christopher Kings-Lynne <chriskl@familyhealth.com.au>

View thread
From: Christopher Kings-Lynne <chriskl@familyhealth.com.au>
To: Brian Tarbox <btarbox@theworld.com>
Cc: Rafal Kedziorski <rafcio@polonium.de>, <pgsql-performance@postgresql.org>
Date: 2003-07-04T13:50:26Z
Lists: pgsql-hackers, pgsql-performance 
> 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.

I have never found a query in MySQL that was faster than one in
PostgreSQL.

Chris