Re: Bad plan when join on function

От: Tom Lane
Тема: Re: Bad plan when join on function
Дата: ,
Msg-id: 21547.1295300024@sss.pgh.pa.us
(см: обсуждение, исходный текст)
Ответ на: Re: Bad plan when join on function  (Pavel Stehule)
Ответы: Re: Bad plan when join on function  (Pavel Stehule)
Список: pgsql-performance

Скрыть дерево обсуждения

Bad plan when join on function  (Zotov, )
 Re: Bad plan when join on function  (Pavel Stehule, )
 Re: Bad plan when join on function  ("Kevin Grittner", )
  Re: Bad plan when join on function  (Pavel Stehule, )
   Re: Bad plan when join on function  (Tom Lane, )
    Re: Bad plan when join on function  (Pavel Stehule, )
 Re: Bad plan when join on function  (Shaun Thomas, )

Pavel Stehule <> writes:
> it should to work without functional index - but not sure about effectivity

As long as the function is VOLATILE, the planner can't use any
intelligent query plan.  Merge or hash join both require at least
stable join keys.

            regards, tom lane


В списке pgsql-performance по дате сообщения:

От: Fernando Hevia
Дата:
Сообщение: Re: Problem with query
От: Achilleas Mantzios
Дата:
Сообщение: Re: "NOT IN" substantially slower in 9.0.2 than 8.3.13 - NOT EXISTS runs fast in both 8.3.13 and 9.0.2