X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 412B5D1B523 for ; Wed, 19 Nov 2003 19:29:32 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 47470-02 for ; Wed, 19 Nov 2003 15:29:01 -0400 (AST) Received: from nitrogen.id.pl (nitrogen.id.pl [193.178.214.5]) by svr1.postgresql.org (Postfix) with SMTP id 53390D1C96A for ; Wed, 19 Nov 2003 15:28:59 -0400 (AST) Received: (qmail 8593 invoked by uid 0); 19 Nov 2003 19:28:59 -0000 Received: from unknown (HELO siaco.id.pl) (213.25.114.8) by smtp.id.pl with SMTP; 19 Nov 2003 19:28:59 -0000 Received: (qmail 19907 invoked by uid 1000); 19 Nov 2003 19:28:55 -0000 Date: Wed, 19 Nov 2003 20:28:55 +0100 From: Ryszard Lach To: Bruce Momjian Cc: pgsql-performance@postgresql.org Subject: Re: duration logging setting in 7.4 Message-ID: <20031119192855.GO18018@siaco.id.pl> Reply-To: Ryszard Lach References: <20031119183824.GL18018@siaco.id.pl> <200311191858.hAJIwR810214@candle.pha.pa.us> Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-2 Content-Disposition: inline In-Reply-To: <200311191858.hAJIwR810214@candle.pha.pa.us> X-My-GPG-Key: echo | mail -s "send key pub" ryszard@lach.name User-Agent: Mutt/1.5.4i X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200311/168 X-Sequence-Number: 4728 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.