Re: Prepared statement not using index

Поиск
Список
Период
Сортировка
От Greg Sabino Mullane
Тема Re: Prepared statement not using index
Дата
Msg-id fba827428f18f4eaeec31eeb96cef685@biglumber.com
обсуждение исходный текст
Ответ на Re: Prepared statement not using index  (Dave Cramer <pg@fastcrypt.com>)
Ответы Re: Prepared statement not using index
Список pgsql-performance
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


> 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).
>
> The 7.4 driver just replaces the ? with the value and doesn't use
> server side prepared statements.

DBD::Pg has a few flags that enables you to do things like purposely avoid
using server side prepares, and force a reprepare of a particular statement.
Perhaps something like that is available for the JDBC driver? If not,
maybe someone would be willing to add it in?

- --
Greg Sabino Mullane greg@turnstep.com
PGP Key: 0x14964AC8 200509120925
https://www.biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8

-----BEGIN PGP SIGNATURE-----

iEYEARECAAYFAkMlgdAACgkQvJuQZxSWSsjMlQCePc4dpE0BCT3W//y/N9uolkmK
ViIAnjR1fF14KbP+cX+xV8lmdlL6Be2k
=NtXw
-----END PGP SIGNATURE-----



В списке pgsql-performance по дате отправления:

Предыдущее
От: Guido Neitzer
Дата:
Сообщение: Re: Prepared statement not using index
Следующее
От: Bruno Wolff III
Дата:
Сообщение: Re: Slow update