Re: General DB Tuning - Mailing list pgsql-performance

From Simon Riggs
Subject Re: General DB Tuning
Date
Msg-id 1121271006.3970.268.camel@localhost.localdomain
Whole thread Raw
In response to Re: General DB Tuning  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
List pgsql-performance
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


pgsql-performance by date:

Previous
From: Simon Riggs
Date:
Subject: Re: size of cache
Next
From: Ian Westmacott
Date:
Subject: Re: cost-based vacuum