Re: Prepared statement not using index - Mailing list pgsql-performance

From Dave Cramer
Subject Re: Prepared statement not using index
Date
Msg-id 9E7179CC-5E87-4DDD-8541-671BF4CA09BD@fastcrypt.com
Whole thread Raw
In response to Re: Prepared statement not using index  (Guido Neitzer <guido.neitzer@pharmaline.de>)
List pgsql-performance
On 12-Sep-05, at 9:22 AM, Guido Neitzer wrote:

> On 12.09.2005, at 14:38 Uhr, Dave Cramer wrote:
>
>
>> The difference between the 7.4 driver and the 8.0.3 driver is the
>> 8.0.3 driver is using server side prepared statements and binding
>> the parameter to the type in setXXX(n,val).
>>
>
> Would be a good idea when this were configurable.
You found the configuration for it
>
> I found my solution (use the JDBC2 drivers with protocolVersion=2),
> but how long will this work?

I think you would be better understanding what the correct type is
for the index to work properly.
>
> cug
>
>


pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Slow update
Next
From: Dave Cramer
Date:
Subject: Re: Prepared statement not using index