Roberto Mello [EMAIL PROTECTED] writes:
On Thu, Feb 13, 2003 at 09:02:05AM -0800, Josh Berkus wrote:
Unless you know something I don't, I do not believe that PL/pgSQL stores
execution plans for functions.
AFAIK execution plans for PL/pgSQL functions were cached once per backend.
No?
Yes.
Johnny,
Does postgres store execution plan's for user-defined SQL functions as the
PL/pgSQL interpreter does. And if so - will this only be prepared after an
initial call to the function? Can't seem to find this information in the
docs!? Thanks,
Unless you know something I don't, I do not