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
> 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
Department of Computer Science
Erik Jonsson School of Engineering and Computer Science
University of Texas at Dallas
In response to
pgsql-performance by date
|Next:||From: Scott Marlowe||Date: 2009-02-23 23:37:04|
|Subject: Re: Abnormal performance difference between Postgres and MySQL|
|Previous:||From: Scott Marlowe||Date: 2009-02-23 23:33:49|
|Subject: Re: postgreSQL performance 8.2.6 vs 8.3.3|