X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 39BA7D8836 for ; Mon, 12 Sep 2005 10:26:45 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 25630-06 for ; Mon, 12 Sep 2005 13:26:39 +0000 (GMT) Received: from biglumber.com (biglumber.com [207.228.252.42]) by svr1.postgresql.org (Postfix) with SMTP id D9358D869B for ; Mon, 12 Sep 2005 10:26:39 -0300 (ADT) Received: (qmail 31671 invoked from network); 12 Sep 2005 13:26:44 -0000 Received: from unknown (HELO localhost) (207.228.252.42) by 0 with SMTP; 12 Sep 2005 13:26:44 -0000 From: "Greg Sabino Mullane" To: pgsql-performance@postgresql.org Subject: Re: Prepared statement not using index X-PGP-Key: 2529 DF6A B8F7 9407 E944 45B4 BC9B 9067 1496 4AC8 X-Request-PGP: http://www.biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 In-Reply-To: <8800F410-0A1C-4AD4-96F0-B3193638056F@fastcrypt.com> Date: Mon, 12 Sep 2005 13:26:44 -0000 X-Mailer: JoyMail 1.48 Message-ID: X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.093 required=5 tests=[AWL=0.093] X-Spam-Level: X-Archive-Number: 200509/141 X-Sequence-Number: 14449 -----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-----