Postgres Pro
Downloads
Home   >   mailing lists

Re: left outer join terrible slow compared to inner join - Mailing list pgsql-general

From Tom Lane
Subject Re: left outer join terrible slow compared to inner join
Date
Msg-id 9637.1062097379@sss.pgh.pa.us
Whole thread Raw
In response to Re: left outer join terrible slow compared to inner join  (Stephen Frost <sfrost@snowman.net>)
List pgsql-general
Tree view 
Stephen Frost <sfrost@snowman.net> writes:
> * Clay Luther (claycle@cisco.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

pgsql-general by date:

Previous
From: Stephen Frost
Date:
Subject: Re: left outer join terrible slow compared to inner join
Next
From: Thomas Beutin
Date:
Subject: Re: left outer join terrible slow compared to inner join