SEO
vBulletin Search Engine Optimization
| |||||||
![Re: [HACKERS] RQ: Prepared statements used by multiple connections](http://unixadmintalk.com/iconimages/f43/re-hackers-rq-prepared-statements-used-multiple-connections_ltr.gif)
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-16-2008, 01:02 AM
| ||||
| ||||
 Re: [HACKERS] RQ: Prepared statements used by multiple connections 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      |
 |
« Free Playstation 3 (PS3) here !
|
Re: Error connecting a visual studio .NET "app" and PostgreSQL »
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
All times are GMT. The time now is 09:23 PM.
