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 52779D8AF1 for ; Mon, 12 Sep 2005 12:28:37 -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 63402-02 for ; Mon, 12 Sep 2005 15:28:34 +0000 (GMT) Received: from net2.micro-automation.com (net2.micro-automation.com [64.7.141.29]) by svr1.postgresql.org (Postfix) with SMTP id 4FBF1D8A86 for ; Mon, 12 Sep 2005 12:28:33 -0300 (ADT) Received: (qmail 21481 invoked from network); 12 Sep 2005 15:28:28 -0000 Received: from dcdsl.ebox.com (HELO ?192.168.1.2?) (davec@64.7.143.116) by net2.micro-automation.com with SMTP; 12 Sep 2005 15:28:28 -0000 In-Reply-To: <410580B5-429B-421B-9469-72EDECC4D7D5@pharmaline.de> References: <08E57775-5E88-42B0-926D-21CAFB21CF24@pharmaline.de> <8800F410-0A1C-4AD4-96F0-B3193638056F@fastcrypt.com> <410580B5-429B-421B-9469-72EDECC4D7D5@pharmaline.de> Mime-Version: 1.0 (Apple Message framework v734) Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed Message-Id: <9E7179CC-5E87-4DDD-8541-671BF4CA09BD@fastcrypt.com> Cc: pgsql-performance@postgresql.org Content-Transfer-Encoding: 7bit From: Dave Cramer Subject: Re: Prepared statement not using index Date: Mon, 12 Sep 2005 11:28:27 -0400 To: Guido Neitzer X-Mailer: Apple Mail (2.734) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.013 required=5 tests=[AWL=0.013] X-Spam-Level: X-Archive-Number: 200509/144 X-Sequence-Number: 14452 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 > >