Changing function from SECURITY DEFINER to SECURITY INVOKER changes query plan?

Поиск
Список
Период
Сортировка
От Joe Van Dyk
Тема Changing function from SECURITY DEFINER to SECURITY INVOKER changes query plan?
Дата
Msg-id CACfv+p+aO1hwi+YjN7Gw8Vcpwn3_LLzQSAN0HhwVu4EuP4hO=w@mail.gmail.com
обсуждение исходный текст
Ответы Re: Changing function from SECURITY DEFINER to SECURITY INVOKER changes query plan?
Список pgsql-general
Дерево обсуждения
I had a function that was set to SECURITY INVOKER. I needed to give access to a view that uses this function to a role, so I made the function SECURITY DEFINER.

The function is STABLE and is usually inlined and takes 2 ms to run.

Immediately, the function quit being inlined and took 1500ms to run.

Changing the function back to SECURITY DEFINER let the function be inlined again.

On postgresql 9.3.1.

Is this expected behavior? 

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

Предыдущее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: Primary Key
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Changing function from SECURITY DEFINER to SECURITY INVOKER changes query plan?