|
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? |
