Re: binary patch problems - Mailing list pgsql-jdbc

From Craig Ringer
Subject Re: binary patch problems
Date
Msg-id 4E781E05.5090203@ringerc.id.au
Whole thread Raw
In response to Re: binary patch problems  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-jdbc
On 09/20/2011 08:39 AM, Tom Lane wrote:
> Maciek Sakrejda<msakrejda@truviso.com>  writes:
>> I think what Tom is saying is that you'll be able to set
>> prepareThreshold to 1 in the driver (always use named server-side
>> prepared statements) and the server will automagically do the right
>> thing. Right now, the big problem is that only unnamed prepared
>> statements include the "feature" of being able to consider parameters
>> in the query plan (since unnamed statements are not reused, there's no
>> sense in planning them before you have parameters).
> Right.  We've rejiggered the backend so that planning is delayed until
> parameter values are available in all cases.

Oooh, exciting. That'll cut down on a whole class of mailing list query
and get rid of a classic gotcha.

Time for me to build git and start playing.

--
Craig Ringer

pgsql-jdbc by date:

Previous
From: Tom Lane
Date:
Subject: Re: binary patch problems
Next
From: Radosław Smogura
Date:
Subject: Re: behavior at the end of a transaction