Re: left outer join terrible slow compared to inner join

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Clay Luther <claycle(at)cisco(dot)com>
Cc: Stephen Frost <sfrost(at)snowman(dot)net>, pgsql-general(at)postgresql(dot)org
Subject: Re: left outer join terrible slow compared to inner join
Date: 2003-08-28 19:02:59
Message-ID: 9637.1062097379@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Stephen Frost <sfrost(at)snowman(dot)net> writes:
> * Clay Luther (claycle(at)cisco(dot)com) wrote:
>> I'd be happy to forward the explain to anyone who'd care to look at it...

> Could you try 7.4b1? It sounds like maybe things are better there from
> what Tom was saying for left outer joins..

If it's not better in 7.4, please send me the details.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Thomas Beutin 2003-08-28 19:11:40 Re: left outer join terrible slow compared to inner join
Previous Message Stephen Frost 2003-08-28 18:51:22 Re: left outer join terrible slow compared to inner join