From: Simon Riggs <simon@2ndquadrant.com>
To: Christopher Kings-Lynne <chriskl@familyhealth.com.au>
Cc: Brent Henry <bh_pgperf@yahoo.com>
Cc: Dennis <dennis@works4me.com>
Cc: Tom Arthurs <tarthurs@jobflash.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: General DB Tuning
Date: Wed, 13 Jul 2005 17:10:06 +0100
Message-ID: <1121271006.3970.268.camel@localhost.localdomain> (raw)
In-Reply-To: <42D473D4.7040500@familyhealth.com.au>
References: <20050713013630.18625.qmail@web33911.mail.mud.yahoo.com>
<42D473D4.7040500@familyhealth.com.au>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: simon@2ndquadrant.com, chriskl@familyhealth.com.au, bh_pgperf@yahoo.com, dennis@works4me.com, tarthurs@jobflash.com
Subject: Re: General DB Tuning
In-Reply-To: <1121271006.3970.268.camel@localhost.localdomain>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox