Re: left outer join terrible slow compared to inner join

From: Stephen Frost <sfrost(at)snowman(dot)net>
To: Clay Luther <claycle(at)cisco(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Thomas Beutin <tyrone(at)laokoon(dot)IN-Berlin(dot)DE>, pgsql-general(at)postgresql(dot)org
Subject: Re: left outer join terrible slow compared to inner join
Date: 2003-08-28 18:51:22
Message-ID: 20030828185121.GY13329@ns.snowman.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

* 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..

Stephen

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-08-28 19:02:59 Re: left outer join terrible slow compared to inner join
Previous Message Clay Luther 2003-08-28 18:47:28 Re: left outer join terrible slow compared to inner join