Re: SQL Functions vs PL/PgSQL - Mailing list pgsql-sql

From Tom Lane
Subject Re: SQL Functions vs PL/PgSQL
Date
Msg-id 2167.1045181189@sss.pgh.pa.us
Whole thread Raw
In response to Re: SQL Functions vs PL/PgSQL  (Roberto Mello <rmello@cc.usu.edu>)
List pgsql-sql
Roberto Mello <rmello@cc.usu.edu> 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.  This is explained in the docs ...
http://www.ca.postgresql.org/users-lounge/docs/7.3/postgres/plpgsql.html#PLPGSQL-OVERVIEW
        regards, tom lane


pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: Debugging postmaster to fix possible bug in Postgres? Followup
Next
From: "Eduardo"
Date:
Subject: PL/PGSQL EDITOR