Postgres Pro
Downloads
Home   >   mailing lists

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

From Gregory Stark
Subject Re: Abnormal performance difference between Postgres and MySQL
Date
Msg-id 87eixozqcp.fsf@oxford.xeocode.com
Whole thread Raw
In response to Abnormal performance difference between Postgres and MySQL  (Farhan Husain <russoue@gmail.com>)
Responses Re: Abnormal performance difference between Postgres and MySQL  (Farhan Husain <russoue@gmail.com>)
Re: Abnormal performance difference between Postgres and MySQL  (Farhan Husain <russoue@gmail.com>)
Re: Abnormal performance difference between Postgres and MySQL  (Farhan Husain <russoue@gmail.com>)
List pgsql-performance
Tree view 
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!

pgsql-performance by date:

Previous
From: Farhan Husain
Date:
Subject: Abnormal performance difference between Postgres and MySQL
Next
From: Scott Marlowe
Date:
Subject: Re: Abnormal performance difference between Postgres and MySQL