Re: CREATE FUNCTION ... performance boost?

On 6/29/07, Jan Danielsson <jan(dot)m(dot)danielsson(at)gmail(dot)com> wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA512
>
> Hello all,
>
> In order to speed up commonly used queries, I use prepared
> statements. I assume that 'prepare' tells some database query planner to
> take a look at a query, and do all preparations for it, then store those
> preparations somewhere for when it's needed.
>
> When I use CREATE FUNCTION to create a function, does that also get
> "planned" automatically (plsql, specifically). My gut feeling is that it
> doesn't (mainly since it can be any external language).

by the way, query plans are exposed through spi interface so all pl
languages have ability to store plans. pl/sql saves plans as well as
static sql in pl/pgsql. ymmv on various other pls.

merlin