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?
