Re: merge join killing performance

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: merge join killing performance
Дата
Msg-id 15062.1275009386@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: merge join killing performance  (Scott Marlowe <scott.marlowe@gmail.com>)
Ответы Re: merge join killing performance  (Scott Marlowe <scott.marlowe@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Bryan Hinton
Дата:
Сообщение: Re: Random Page Cost and Planner
Следующее
От: Mark Wong
Дата:
Сообщение: hp hpsa vs cciss driver