Re: Create one prepared function

From: Neil Conway <neilc(at)samurai(dot)com>
To: Marcos José Setim <mjs_ops(at)gmx(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Create one prepared function
Date: 2006-01-08 04:00:52
Message-ID: 1136692852.9135.14.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Neil Conway 2006-01-08 04:04:30 Re: Performance Low Using the Prepare and Execute
Previous Message Assad Jarrahian 2006-01-08 03:28:28 SQLData user-defined-types and getObject()