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

From Greg Sabino Mullane
Subject Re: Prepared statement not using index
Date
Msg-id fba827428f18f4eaeec31eeb96cef685@biglumber.com
Whole thread Raw
In response to Re: Prepared statement not using index  (Dave Cramer <pg@fastcrypt.com>)
Responses Re: Prepared statement not using index
List 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 by date:

Previous
From: Guido Neitzer
Date:
Subject: Re: Prepared statement not using index
Next
From: Bruno Wolff III
Date:
Subject: Re: Slow update