On Tue, Jan 25, 2005 at 10:36:34AM +0000, Christopher Kings-Lynne wrote: > > > >... 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.
How did you test it? You can use settings like debug_print_plan and client_min_messages to see what's happening in each backend. -- Michael Fuhr http://www.fuhr.org/~mfuhr/ ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
