Re: Prepared statement not using index

From: Dave Cramer <pg(at)fastcrypt(dot)com>
To: Guido Neitzer <guido(dot)neitzer(at)pharmaline(dot)de>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Prepared statement not using index
Date: 2005-09-12 15:28:27
Message-ID: 9E7179CC-5E87-4DDD-8541-671BF4CA09BD@fastcrypt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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
>
>

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Dave Cramer 2005-09-12 15:30:14 Re: Prepared statement not using index
Previous Message Tom Lane 2005-09-12 14:07:26 Re: Slow update