Re: Looking for tips - Mailing list pgsql-performance

From Jeff Trout
Subject Re: Looking for tips
Date
Msg-id 654C15AD-4ADF-4792-8082-BE94ECF86F3A@torgo.978.org
Whole thread Raw
In response to Re: Looking for tips  ("Steinar H. Gunderson" <sgunderson@bigfoot.com>)
List pgsql-performance
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 <jeff@jefftrout.com>
http://www.jefftrout.com/
http://www.stuarthamm.net/



pgsql-performance by date:

Previous
From: "Steinar H. Gunderson"
Date:
Subject: Re: Looking for tips
Next
From: Oliver Crosby
Date:
Subject: Re: Looking for tips