Re: Slow inner join, but left join is fast

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: "Jeremy Haile" <jhaile@xxxxxxxxxxx>
Subject: Re: Slow inner join, but left join is fast
From: Tom Lane <tgl@xxxxxxxxxxxxx>
Date: Wed, 10 Jan 2007 12:15:44 -0500
Cc: pgsql-performance@xxxxxxxxxxxxxx
Comments: In-reply-to "Jeremy Haile" <jhaile@xxxxxxxxxxx> message dated "Wed, 10 Jan 2007 11:17:22 -0500"
In-reply-to: <1168445842.5566.1168570133@xxxxxxxxxxxxxxxxxxxxxxxxxxx>
References: <1168445842.5566.1168570133@xxxxxxxxxxxxxxxxxxxxxxxxxxx>

"Jeremy Haile" <jhaile@xxxxxxxxxxx> 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

Follow-Ups:
- Re: Slow inner join, but left join is fast
  - From: Jeremy Haile

References:
- Slow inner join, but left join is fast
  - From: Jeremy Haile

Prev by Date: Re: group by will not use an index?
Next by Date: Re: Slow inner join, but left join is fast
Previous by thread: Slow inner join, but left join is fast
Next by thread: Re: Slow inner join, but left join is fast
Index(es):
- Date
- Thread

[Postgresql General] [Postgresql PHP] [PHP Users] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Yosemite]

Powered by Linux