Re: Create one prepared function - Mailing list pgsql-general

From Neil Conway
Subject Re: Create one prepared function
Date
Msg-id 1136692852.9135.14.camel@localhost.localdomain
Whole thread Raw
In response to Create one prepared function  (Marcos José Setim <mjs_ops@gmx.net>)
List pgsql-general
On Sun, 2006-01-08 at 00:12 +0000, Marcos José Setim wrote:
> I'd like that create functions in plpgsql with prepared SQL and plan
> saved, to that the Postgresl increase the performance of executions.
>
> This is possible?

plpgsql internally caches query plans the first time a function is
invoked in a given session, so there is probably no (performance) reason
to do it by hand.

-Neil



pgsql-general by date:

Previous
From: Assad Jarrahian
Date:
Subject: SQLData user-defined-types and getObject()
Next
From: Neil Conway
Date:
Subject: Re: Performance Low Using the Prepare and Execute