| From: | Hannu Krosing <hannu(at)tm(dot)ee> |
|---|---|
| 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-06 00:11:58 |
| Message-ID: | 1057450318.17490.8.camel@fuji.krosing.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-docs pgsql-general pgsql-hackers pgsql-performance |
Brian Tarbox kirjutas R, 04.07.2003 kell 15:27:
> 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.
For each and every query ??
> We were on this list a fair bit looking for answers and tried all the
> standard answers.
Could you post the list of "standard answers" you tried ?
> It was still much much much slower.
Was this with InnoDB ?
what kind of joins were they (i.e
"FROM a JOIN b on a.i=b.i"
or "FROM a,b WHERE a.i = b.i" ?
What was the ratio of planning time to actual execution time in pgsql?
Where the queries originally optimized for MySQL ?
----------------
Hannu
| From | Date | Subject | |
|---|---|---|---|
| Next Message | scott.marlowe | 2003-07-07 17:35:24 | Re: PostgreSQL vs. MySQL |
| Previous Message | Hilmar Lapp | 2003-07-05 23:40:52 | Re: PostgreSQL vs. MySQL |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephan Szabo | 2003-07-06 01:37:25 | Re: Record locking in deadlock |
| Previous Message | Hilmar Lapp | 2003-07-05 23:40:52 | Re: PostgreSQL vs. MySQL |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2003-07-06 01:51:16 | Re: vacuum does not reclaim rows |
| Previous Message | Hilmar Lapp | 2003-07-05 23:40:52 | Re: PostgreSQL vs. MySQL |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sean Chittenden | 2003-07-06 00:24:13 | Re: Moving postgresql.conf tunables into 2003... |
| Previous Message | Hilmar Lapp | 2003-07-05 23:40:52 | Re: PostgreSQL vs. MySQL |