Location via proxy:   [ UP ]  
[Report a bug]   [Manage cookies]                
Postgres Pro
Downloads
Home   >   mailing lists

Re: Abnormal performance difference between Postgres and MySQL - Mailing list pgsql-performance

From Farhan Husain
Subject Re: Abnormal performance difference between Postgres and MySQL
Date
Msg-id 3df32b6d0902231535i538ea8c7m651d9ce16f9eefe0@mail.gmail.com
Whole thread Raw
In response to Re: Abnormal performance difference between Postgres and MySQL  (Gregory Stark <stark@enterprisedb.com>)
Responses Re: Abnormal performance difference between Postgres and MySQL
List pgsql-performance
Tree view


On Mon, Feb 23, 2009 at 5:27 PM, Gregory Stark <stark@enterprisedb.com> wrote:
Farhan Husain <russoue@gmail.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

pgsql-performance by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: postgreSQL performance 8.2.6 vs 8.3.3
Next
From: Scott Marlowe
Date:
Subject: Re: Abnormal performance difference between Postgres and MySQL