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