Re: Prepared statement not using index

Поиск
Список
Период
Сортировка
От Dave Cramer
Тема Re: Prepared statement not using index
Дата
Msg-id 9E7179CC-5E87-4DDD-8541-671BF4CA09BD@fastcrypt.com
обсуждение исходный текст
Ответ на Re: Prepared statement not using index  (Guido Neitzer <guido.neitzer@pharmaline.de>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Slow update
Следующее
От: Dave Cramer
Дата:
Сообщение: Re: Prepared statement not using index