Re: PREPARE / EXECUTE

>
>
>
>The standard approach to such a scenario would imho be to write stored procedures
>for the complex queries (e.g. plpgsql) and use that from the client.
>Maybe even eliminate a few ping pongs between client and server.
>
>Andreas
>
>

Does it reduce the time taken by the planner?
Are server side SQL functions optimized at runtime or at "create
function" time?

If the function is optimized at runtime it is not a gain.

Hans

--
*Cybertec Geschwinde u Schoenig*
Ludo-Hartmannplatz 1/14, A-1160 Vienna, Austria
Tel: +43/1/913 68 09; +43/664/233 90 75
www.postgresql.at <http://www.postgresql.at>, cluster.postgresql.at
<http://cluster.postgresql.at>, www.cybertec.at
<http://www.cybertec.at>, kernel.cybertec.at <http://kernel.cybertec.at>