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

Поиск
Список
Период
Сортировка
От Michael Fuhr
Тема Re: [HACKERS] RQ: Prepared statements used by multiple connections
Дата
Msg-id 20050125214648.GB95908@winnie.fuhr.org
обсуждение исходный текст
Ответ на Re: [HACKERS] RQ: Prepared statements used by multiple connections  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
Список pgsql-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/

В списке pgsql-odbc по дате отправления:

Предыдущее
От: George Weaver
Дата:
Сообщение: Re: Error connecting a visual studio .NET "app" and PostgreSQL
Следующее
От: lothar.behrens@lollisoft.de
Дата:
Сообщение: Re: ODBC (win32) X PostgreSQL(Linux)