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;