"Jeremy Haile" <[EMAIL PROTECTED]> writes:
> I have a query made by joining two subqueries where the outer query
> performing the join takes significantly longer to run than the two
> subqueries.
Please show EXPLAIN ANALYZE results, not just EXPLAIN.
Also, have you analyzed your tables recently?
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match