Skip site navigation (1) Skip section navigation (2)

Re: Abnormal performance difference between Postgres and MySQL

From: Farhan Husain <russoue(at)gmail(dot)com>
To: Gregory Stark <stark(at)enterprisedb(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Abnormal performance difference between Postgres and MySQL
Date: 2009-02-23 23:35:21
Message-ID: 3df32b6d0902231535i538ea8c7m651d9ce16f9eefe0@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
On Mon, Feb 23, 2009 at 5:27 PM, Gregory Stark <stark(at)enterprisedb(dot)com>wrote:

> Farhan Husain <russoue(at)gmail(dot)com> writes:
>
> > I can provide any other information needed and also the data if anyone
> > wants.
>
> What did the query plans look like in both databases?
>
> In Postgres you can get the query plan with
>
> EXPLAIN ANALYZE select ...
>
> You can leave out the ANALYZE if you can't wait until the query completes
> but
> it will have much less information to diagnosis any problems.
>
> --
>  Gregory Stark
>  EnterpriseDB          http://www.enterprisedb.com
>  Ask me about EnterpriseDB's Slony Replication support!
>

I am doing the EXPLAIN ANALYZE now, it will take about 1 hour and 20 minutes
again. I will get back to you once it is finished. Do you know how to get
the query plan in MySQL?

-- 
Mohammad Farhan Husain
Research Assistant
Department of Computer Science
Erik Jonsson School of Engineering and Computer Science
University of Texas at Dallas

In response to

Responses

pgsql-performance by date

Next:From: Scott MarloweDate: 2009-02-23 23:37:04
Subject: Re: Abnormal performance difference between Postgres and MySQL
Previous:From: Scott MarloweDate: 2009-02-23 23:33:49
Subject: Re: postgreSQL performance 8.2.6 vs 8.3.3

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group