Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Abnormal performance difference between Postgres and MySQL
- From: Gregory Stark <stark(at)enterprisedb(dot)com>
- To: Farhan Husain <russoue(at)gmail(dot)com>
- Cc: pgsql-performance(at)postgresql(dot)org
- Subject: Re: Abnormal performance difference between Postgres and MySQL
- Date: Mon, 23 Feb 2009 23:27:18 +0000
- Message-id: <87eixozqcp.fsf@oxford.xeocode.com> <text/plain>
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!
- Follow-Ups:
- Re: Abnormal performance difference between Postgres and MySQL
- From: Farhan Husain
- Re: Abnormal performance difference between Postgres and MySQL
- From: Farhan Husain
- Re: Abnormal performance difference between Postgres and MySQL
- From: Farhan Husain
- Re: Abnormal performance difference between Postgres and MySQL
- References:
- Abnormal performance difference between Postgres and MySQL
- From: Farhan Husain
- Abnormal performance difference between Postgres and MySQL
- Prev by Date: Abnormal performance difference between Postgres and MySQL
- Next by Date: Re: Abnormal performance difference between Postgres and MySQL
- Previous by thread: Abnormal performance difference between Postgres and MySQL
- Next by thread: Re: Abnormal performance difference between Postgres and MySQL
- Indexes: