Re: PostgreSQL vs. MySQL

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Brian Tarbox" <btarbox(at)theworld(dot)com>
Cc: "Rafal Kedziorski" <rafcio(at)polonium(dot)de>, pgsql-performance(at)postgresql(dot)org
Subject: Re: PostgreSQL vs. MySQL
Date: 2003-07-04 13:59:13
Message-ID: 15241.1057327153@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs pgsql-general pgsql-hackers pgsql-performance

"Brian Tarbox" <btarbox(at)theworld(dot)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

In response to

Browse pgsql-docs by date

  From Date Subject
Next Message Brian Tarbox 2003-07-04 14:07:46 Re: PostgreSQL vs. MySQL
Previous Message Christopher Kings-Lynne 2003-07-04 13:50:26 Re: PostgreSQL vs. MySQL

Browse pgsql-general by date

  From Date Subject
Next Message Brian Tarbox 2003-07-04 14:07:46 Re: PostgreSQL vs. MySQL
Previous Message Christopher Kings-Lynne 2003-07-04 13:50:26 Re: PostgreSQL vs. MySQL

Browse pgsql-hackers by date

  From Date Subject
Next Message Brian Tarbox 2003-07-04 14:07:46 Re: PostgreSQL vs. MySQL
Previous Message Tom Lane 2003-07-04 13:50:50 Re: cvs version compile error

Browse pgsql-performance by date

  From Date Subject
Next Message Brian Tarbox 2003-07-04 14:07:46 Re: PostgreSQL vs. MySQL
Previous Message Christopher Kings-Lynne 2003-07-04 13:50:26 Re: PostgreSQL vs. MySQL