Return Multiple Rows from Store Function

[Brahmam Eswar <brahmam1234@xxxxxxxxx>]

Hi ,

Returning multiple rows from store functions using "RETURNS TABLE" and RETURN QUERY.  The results set may have more than 50k records. Does it give any performance issues related to memory? if yes  how to avoid it

CREATE OR REPLACE FUNCTION funcq(COL1 character varying)

) 

RETURNS TABLE 

( a VARCHAR,

  b VARCHAR,

  c varchar)

 AS $$

BEGIN

    

      RETURN QUERY SELECT a,b,c from table1 where C= COL1;

END;

$$

LANGUAGE plpgsql;

--

Thanks & Regards,
Brahmeswara Rao J.