Re: BUG #5165: Poor performance with Left-join where right side does not exist - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #5165: Poor performance with Left-join where right side does not exist
Date
Msg-id 20626.1257434488@sss.pgh.pa.us
Whole thread Raw
In response to Re: BUG #5165: Poor performance with Left-join where right side does not exist  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Responses Re: BUG #5165: Poor performance with Left-join where right side does not exist  (assaf lehr <assaf_lehr@yahoo.com>)
List pgsql-bugs
"Kevin Grittner" <Kevin.Grittner@wicourts.gov> writes:
> assaf lehr <assaf_lehr@yahoo.com> wrote:
>> let me explain it better.
>> [hand-waving and pseudo-code]

> People would like to help you, but you're not providing enough
> information to let them.

Well, the really important point is that this query is using a
construction that was specifically improved in 8.4.  The advice
is still going to be the same: see if it isn't better with 8.4.

            regards, tom lane

pgsql-bugs by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: BUG #5165: Poor performance with Left-join where right side does not exist
Next
From: Robert Haas
Date:
Subject: Re: BUG #5168: cannot login to server