Re: Performance problem on RH7.1

=?iso-8859-2?Q?Egy=FCd_Csaba?= <csegyud@vnet.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