X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 01BDD52A08 for ; Wed, 13 Jul 2005 13:10:26 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 83642-03 for ; Wed, 13 Jul 2005 16:10:21 +0000 (GMT) Received: from cmailg1.svr.pol.co.uk (cmailg1.svr.pol.co.uk [195.92.195.171]) by svr1.postgresql.org (Postfix) with ESMTP id 8F7D452BCF for ; Wed, 13 Jul 2005 13:10:18 -0300 (ADT) Received: from modem-2867.leopard.dialup.pol.co.uk ([217.135.155.51] helo=192.168.0.102) by cmailg1.svr.pol.co.uk with esmtp (Exim 4.41) id 1DsjoL-0007Kq-2r; Wed, 13 Jul 2005 17:10:13 +0100 Subject: Re: General DB Tuning From: Simon Riggs To: Christopher Kings-Lynne Cc: Brent Henry , Dennis , Tom Arthurs , pgsql-performance@postgresql.org In-Reply-To: <42D473D4.7040500@familyhealth.com.au> References: <20050713013630.18625.qmail@web33911.mail.mud.yahoo.com> <42D473D4.7040500@familyhealth.com.au> Content-Type: text/plain Organization: 2nd Quadrant Date: Wed, 13 Jul 2005 17:10:06 +0100 Message-Id: <1121271006.3970.268.camel@localhost.localdomain> Mime-Version: 1.0 X-Mailer: Evolution 2.0.2 (2.0.2-3) Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.052 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200507/142 X-Sequence-Number: 13383 On Wed, 2005-07-13 at 09:52 +0800, Christopher Kings-Lynne wrote: > > Is there a different kind of 'prepared' statements > > that we should be using in the driver to get logging > > to work properly? What is the 'new' protocol? > > The 8.0.2 jdbc driver uses real prepared statements instead of faked > ones. The problem is the new protocol (that the 8.0.2 driver users) has > a bug where protocol-prepared queries don't get logged properly. > > I don't know if it's been fixed... Yes, there is a fix for this in 8.1 Brent has been sent the details. Best Regards, Simon Riggs