Re: Printing query durations

Поиск
Список
Период
Сортировка
От Kevin Dorne
Тема Re: Printing query durations
Дата
Msg-id 4428BCB0.2040002@catalyst.net.nz
обсуждение исходный текст
Ответ на Re: Printing query durations  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Printing query durations
Список pgsql-jdbc
Tom Lane wrote:
> Dave Cramer <pg@fastcrypt.com> writes:
>> There is no difference between a jdbc query and a psql query. The
>> backend doesn't know where the query comes from.
>
> However, the backend has different code paths for V2 and V3 protocol,
> and it could be that what he's looking at is a deficiency in the V3
> protocol logging support.  If so, telling jdbc to use V2 would help.
> (I'm being tentative about this because the backend version was not
> mentioned --- we've fixed some of that stuff in recent releases.)

Well, to clarify, we're using PostgreSQL 7.4.7.  I'm not actually sure
what JDBC version we're using, as I've just encountered a
(usefully-named) postgresql.jar file, but I'm fairly certain it's an
8.1.x.  Is there an easy way to tell?

And yes, we are using V3 protocol.

-k


Вложения

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

Предыдущее
От: Dave Cramer
Дата:
Сообщение: Re: Printing query durations
Следующее
От: Simon Riggs
Дата:
Сообщение: Re: Printing query durations