Hi:
I have PL-PgSQL function that returns a set of records. It builds up 2 temp tables and then queries them to generate the set of records to be returned a-la....
for rrec in
select t1.x, t2.x from t1, t2 where....
loop
return next rrec;
end loop;
I noticed that it takes a long time to return the set of records. But if I run the same query at the psql cli, it runs blindingly fast. So it appears that the process of returning the records via “return next” is the performance culprit.
Any ideas?
