Re: Abnormal performance difference between Postgres and MySQL

[Farhan Husain <russoue(at)gmail(dot)com>]

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