Re: duration logging setting in 7.4

From: Ryszard Lach <siaco(at)autograf(dot)pl>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: duration logging setting in 7.4
Date: 2003-11-19 19:28:55
Message-ID: 20031119192855.GO18018@siaco.id.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Wed, Nov 19, 2003 at 01:58:27PM -0500, Bruce Momjian wrote:
> Ryszard Lach wrote:
>
> > There is another one thing: logs from the same database running on 7.3 and the same
> > application contained lines like 'select getdatabaseencoding()', 'select
> > datestyle()' and similar (not used by application explicite, probably
> > added by JDBC driver), now they are missed - maybe this is the
> > problem?
>
> No, those are missing because the new 7.4 wire protocol doesn't require
> those queries anymore --- the data is send automatically.
>

Mayby this is a solution? Because of some
charset-related problems we are still using an old (AFAiR modified)
version of JDBC driver. I'm not a programmer, but I think and don't know
what JDBC driver does, but maybe it sends from client side those queries
and server doesn't know what to do with them? I'll ask our programmers
to try with 7.4 driver and tell you about results.

Richard.

--
"First they ignore you. Then they laugh at you. Then they
fight you. Then you win." - Mohandas Gandhi.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Bruce Momjian 2003-11-19 19:42:20 Re: duration logging setting in 7.4
Previous Message Ian Barwick 2003-11-19 19:16:48 Re: TEXT column and indexing