"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