=?iso-8859-2?Q?Egy=FCd_Csaba?= <csegyud(at)vnet(dot)hu> writes:
>> I'd also suggest dropping the EXECUTE approach, as this is costing you
>> a re-plan on every call without buying much of anything.
> Do you mean I should use PERFORM instead? Or what else?
> Do you mean the "for R in execute" statements? How can I run a dynamic query
> in other way?
No, I mean the most straightforward way:
for R in select ... where stockid = $1 and ...
This lets plpgsql cache the plan for the SELECT.
regards, tom lane
In response to
pgsql-general by date
|Next:||From: Scrappy||Date: 2004-06-28 18:17:39|
|Subject: Re: Text message|
|Previous:||From: Tom Lane||Date: 2004-06-28 18:04:59|
|Subject: Re: Inconsistant DOW... |