> > ... a prepared version that is local to the backend that invokes the > > function, yes (i.e. it will be planned once per backend). So ISTM this > > is equivalent functionality to what you can get using PREPARE or the > > extended query protocol. > > Are you sure it's only per-backend? I thought I tested it and it seemed > to prepare it everywhere... oh well.
Plpgsql functions at the least are compiled by each backend. I take advantage of this...I use schemas and I don't have to keep a copy of the function for each dataset. I think vanilla sql functions might be different. > Either way, it avoids the problem with prepared queries in that you > cannot know in advance if your query has already been prepared or not. Yep. I like things the way they are, but I can feel the pain of applications that don't (or can't) keep connections open. Merlin ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq