Earlier, I wrote:
Exactly what is gained by the use of persistent prepare over the use of
a stored procedure?
Er, ENOCOFFEE. Sorry.
The benefit is obvious with use of global prepared statements at the
wire protocol level rather than via SQL EXECUTE . It's a lot more
efficient than EXECUTE or SELECT function(params).
It's pretty clear that there are some tricky aspects though, what with
schema search paths, role priveleges, etc.
--
Craig Ringer
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
