Skip site navigation (1) Skip section navigation (2)

Re: [HACKERS] RQ: Prepared statements used by multiple connections

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
Cc: Neil Conway <neilc(at)samurai(dot)com>,Bojidar Mihajlov <bmihajlov(at)yahoo(dot)com>, pgsql-hackers(at)postgresql(dot)org,pgsql-odbc(at)postgresql(dot)org
Subject: Re: [HACKERS] RQ: Prepared statements used by multiple connections
Date: 2005-01-25 21:46:48
Message-ID: 20050125214648.GB95908@winnie.fuhr.org (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-odbc
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/

In response to

pgsql-hackers by date

Next:From: Tom LaneDate: 2005-01-25 21:47:11
Subject: Re: Autotuning Group Commit
Previous:From: Tom LaneDate: 2005-01-25 21:41:57
Subject: Re: Vacuum Looping 7.4

pgsql-odbc by date

Next:From: Bojidar MihajlovDate: 2005-01-26 11:26:25
Subject: Re: RQ: Prepared statements used by multiple connections
Previous:From: George WeaverDate: 2005-01-25 20:30:10
Subject: Re: Error connecting a visual studio .NET "app" and PostgreSQL

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group