Postgres Pro
Downloads
Home   >   mailing lists

Re: plpgsql functions and the planner - Mailing list pgsql-general

From Douglas McNaught
Subject Re: plpgsql functions and the planner
Date
Msg-id 5ded07e00804270645l7e6f9005pca926586ad4e9d8d@mail.gmail.com
Whole thread Raw
In response to plpgsql functions and the planner  ("Matthew Dennis" <mdennis@merfer.net>)
List pgsql-general
Tree view 
On Sun, Apr 27, 2008 at 2:06 AM, Matthew Dennis <mdennis@merfer.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.

-Doug

pgsql-general by date:

Previous
From: Ivan Sergio Borgonovo
Date:
Subject: Re: taking actions on rollback (PHP)
Next
From: Martijn van Oosterhout
Date:
Subject: Re: taking actions on rollback (PHP)