| From: | "Brian Tarbox" <btarbox(at)theworld(dot)com> |
|---|---|
| To: | "Rafal Kedziorski" <rafcio(at)polonium(dot)de>, <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: PostgreSQL vs. MySQL |
| Date: | 2003-07-04 12:27:36 |
| Message-ID: | 01af01c34227$a6cff470$01000001@trouble |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-docs pgsql-general 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.
Brian Tarbox
-----Original Message-----
From: pgsql-performance-owner(at)postgresql(dot)org
[mailto:pgsql-performance-owner(at)postgresql(dot)org]On Behalf Of Rafal
Kedziorski
Sent: Friday, July 04, 2003 6:03 AM
To: pgsql-performance(at)postgresql(dot)org
Subject: [PERFORM] PostgreSQL vs. MySQL
Hi,
has anybody tested PostgreSQL 7.3.x tables agains MySQL 4.0.12/13 with
InnoDB?
Regards,
Rafal
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Mattox | 2003-07-04 12:36:00 | Re: PostgreSQL vs. MySQL |
| Previous Message | Richard Huxton | 2003-07-04 11:12:25 | Re: PostgreSQL vs. MySQL |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Mattox | 2003-07-04 12:36:00 | Re: PostgreSQL vs. MySQL |
| Previous Message | Martin Marques | 2003-07-04 12:12:03 | Re: any body using Solaris8 with postgresql 7.3.3 |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Mattox | 2003-07-04 12:36:00 | Re: PostgreSQL vs. MySQL |
| Previous Message | Jean-Michel POURE | 2003-07-04 11:40:38 | Re: RE : [GENERAL] pgAdmin III - Call for Translators |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rod Taylor | 2003-07-04 12:29:04 | Re: Moving postgresql.conf tunables into 2003... |
| Previous Message | Richard Huxton | 2003-07-04 11:12:25 | Re: PostgreSQL vs. MySQL |