X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id C3F3E528A6 for ; Tue, 19 Jul 2005 16:53:12 -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 34282-04 for ; Tue, 19 Jul 2005 19:53:07 +0000 (GMT) Received: from sccrmhc11.comcast.net (sccrmhc11.comcast.net [204.127.202.55]) by svr1.postgresql.org (Postfix) with ESMTP id B485A52A0D for ; Tue, 19 Jul 2005 16:53:05 -0300 (ADT) Received: from jefftrout.com ([24.147.120.205]) by comcast.net (sccrmhc11) with SMTP id <2005071919530501100qg2nae>; Tue, 19 Jul 2005 19:53:05 +0000 Received: (qmail 85244 invoked from network); 19 Jul 2005 19:59:18 -0000 Received: from c-24-147-120-205.hsd1.ma.comcast.net (HELO ?192.168.0.106?) (24.147.120.205) by 192.168.0.109 with SMTP; 19 Jul 2005 19:59:18 -0000 In-Reply-To: <20050719193601.GA21311@uio.no> References: <1efd553a05071910427b290203@mail.gmail.com> <42DD3D55.9020508@commandprompt.com> <1efd553a050719112126b8d981@mail.gmail.com> <8446.1121799660@sss.pgh.pa.us> <1efd553a05071912111f6a3121@mail.gmail.com> <8613.1121800591@sss.pgh.pa.us> <20050719193601.GA21311@uio.no> Mime-Version: 1.0 (Apple Message framework v733) Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed Message-Id: <654C15AD-4ADF-4792-8082-BE94ECF86F3A@torgo.978.org> Cc: pgsql-performance@postgresql.org Content-Transfer-Encoding: 7bit From: Jeff Trout Subject: Re: Looking for tips Date: Tue, 19 Jul 2005 15:53:04 -0400 To: "Steinar H. Gunderson" X-Mailer: Apple Mail (2.733) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.024 tagged_above=0 required=5 tests=AWL, RCVD_BY_IP X-Spam-Level: X-Archive-Number: 200507/320 X-Sequence-Number: 13561 On Jul 19, 2005, at 3:36 PM, Steinar H. Gunderson wrote: > On Tue, Jul 19, 2005 at 03:16:31PM -0400, Tom Lane wrote: > >> Ah, but are they really prepared, or is DBD::Pg faking it by >> inserting >> parameter values into the query text and then sending the assembled >> string as a fresh query? >> > > They are really prepared. That depends on what version you are using. Older versions did what Tom mentioned rather than sending PREPARE & EXECUTE. Not sure what version that changed in. -- Jeff Trout http://www.jefftrout.com/ http://www.stuarthamm.net/