Postgres Pro
Downloads
Home   >   mailing lists

Re: Slow inner join, but left join is fast - Mailing list pgsql-performance

From Tom Lane
Subject Re: Slow inner join, but left join is fast
Date
Msg-id 10060.1168449344@sss.pgh.pa.us
Whole thread Raw
In response to Slow inner join, but left join is fast  ("Jeremy Haile" <jhaile@fastmail.fm>)
Responses Re: Slow inner join, but left join is fast  ("Jeremy Haile" <jhaile@fastmail.fm>)
List pgsql-performance
Tree view 
"Jeremy Haile" <jhaile@fastmail.fm> 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

pgsql-performance by date:

Previous
From: tsuraan
Date:
Subject: Re: group by will not use an index?
Next
From: "Jeremy Haile"
Date:
Subject: Re: Slow inner join, but left join is fast