Re: duration logging setting in 7.4

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Ryszard Lach <siaco(at)autograf(dot)pl>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: duration logging setting in 7.4
Date: 2003-11-19 19:42:20
Message-ID: 200311191942.hAJJgKR15032@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Rajesh Kumar Mallah 2003-11-20 01:37:30 problem with select count(*) ..
Previous Message Ryszard Lach 2003-11-19 19:28:55 Re: duration logging setting in 7.4