Re: merge join killing performance

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: merge join killing performance
Дата
Msg-id 3829.1274365692@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?

Could be.  I don't have time right now to chase through the code, but
that sounds like a plausible theory.

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Optimize date query for large child tables: GiST or GIN?
Следующее
От: Scott Marlowe
Дата:
Сообщение: Re: merge join killing performance