Re: merge join killing performance - Mailing list pgsql-performance

From Tom Lane
Subject Re: merge join killing performance
Date
Msg-id 15062.1275009386@sss.pgh.pa.us
Whole thread Raw
In response to Re: merge join killing performance  (Scott Marlowe <scott.marlowe@gmail.com>)
Responses Re: merge join killing performance  (Scott Marlowe <scott.marlowe@gmail.com>)
List pgsql-performance
Scott Marlowe <scott.marlowe@gmail.com> writes:
> So, Tom, so you think it's possible that the planner isn't noticing
> all those nulls and thinks it'll just take a row or two to get to the
> value it needs to join on?

I've committed a patch for this, if you're interested in testing that
it fixes your situation.

            regards, tom lane

pgsql-performance by date:

Previous
From: Bryan Hinton
Date:
Subject: Re: Random Page Cost and Planner
Next
From: Mark Wong
Date:
Subject: hp hpsa vs cciss driver