Re: Slow inner join, but left join is fast

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Jeremy Haile" <jhaile(at)fastmail(dot)fm>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Slow inner join, but left join is fast
Date: 2007-01-10 18:38:15
Message-ID: 14865.1168454295@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

"Jeremy Haile" <jhaile(at)fastmail(dot)fm> writes:
> I still don't understand why the inner join would be so different from
> the left join prior to the analyze.

Are you sure you hadn't analyzed in between? Or maybe autovac did it
for you? The reason for the plan change is the change from estimating
1 row matching the transaction_date range constraint, to estimating lots
of them, and the join type away up at the top would surely not have
affected that.

regards, tom lane

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Jeremy Haile 2007-01-10 18:38:24 Re: Slow inner join, but left join is fast
Previous Message Jeremy Haile 2007-01-10 18:20:18 Re: Slow inner join, but left join is fast