Re: duration logging setting in 7.4 - Mailing list pgsql-performance

From Bruce Momjian
Subject Re: duration logging setting in 7.4
Date
Msg-id 200311191942.hAJJgKR15032@candle.pha.pa.us
Whole thread Raw
In response to Re: duration logging setting in 7.4  (Ryszard Lach <siaco@autograf.pl>)
List pgsql-performance
Ryszard Lach wrote:
> 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.

Also, try plain psql and issue a query and see if it appears.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

pgsql-performance by date:

Previous
From: Ryszard Lach
Date:
Subject: Re: duration logging setting in 7.4
Next
From: Tom Lane
Date:
Subject: Re: Backup/restore of pg_statistics