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

"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