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!