Re: Function performance degrades after repeated execution

[Ron]

On 11/16/19 8:22 AM, Dave Roberge wrote:

Hi,

We've been troubleshooting a slow running function in our postgres database. 
I've been able to boil it down to the simplest function possible. It looks like 
this:

FOR rec IN select 1 as matchval FROM table1 t1, table2 t2
   join table3 t3 on t3.col = t2.col
   WHERE t1.col = id
LOOP
   IF rec.matchval > 0 THEN
     co := co + 1;
   END IF;
   if co % 100 = 0 then
     raise notice 'match value %', co;
   end if;
END LOOP;

Where are you joining table1 to either table2 or table3?

--
Angular momentum makes the world go 'round.