Re: Looking for tips

From: Jeff Trout <threshar(at)torgo(dot)978(dot)org>
To: "Steinar H(dot) Gunderson" <sgunderson(at)bigfoot(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Looking for tips
Date: 2005-07-19 19:53:04
Message-ID: 654C15AD-4ADF-4792-8082-BE94ECF86F3A@torgo.978.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)jefftrout(dot)com>
http://www.jefftrout.com/
http://www.stuarthamm.net/

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Mark Wong 2005-07-19 19:54:53 Re: COPY FROM performance improvements
Previous Message Steinar H. Gunderson 2005-07-19 19:36:01 Re: Looking for tips