On Sun, Apr 27, 2008 at 2:06 AM, Matthew Dennis <mdennis(at)merfer(dot)net> wrote:
> Do SQL statements inside of plpgsql functions get planned upon every
> execution, only when the function is first executed/defined, or something
> else entirely?
They are planned on first execution and the plan is cached for later use.
In response to
pgsql-general by date
|Next:||From: Gregory Stark||Date: 2008-04-27 14:30:40|
|Subject: Re: plpgsql functions and the planner|
|Previous:||From: Ivan Sergio Borgonovo||Date: 2008-04-27 12:05:16|
|Subject: Re: taking actions on rollback (PHP)|