Re: merge join killing performance

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: merge join killing performance
Дата
Msg-id AANLkTinBVZmcknJjIQGr_suUnlOoBE8uxG-vGfiA7KWQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: merge join killing performance  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: merge join killing performance
Список pgsql-performance
On Thu, May 27, 2010 at 7:16 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> 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.

Cool, do we have a snapshot build somewhere or do I need to get all
the extra build bits like flex or yacc or bison or whatnot?

В списке pgsql-performance по дате отправления:

Предыдущее
От: Mark Wong
Дата:
Сообщение: hp hpsa vs cciss driver
Следующее
От: Tom Lane
Дата:
Сообщение: Re: merge join killing performance