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
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 |