Binary Refcursor possible? - Mailing list pgsql-performance

From Ralph Mason
Subject Binary Refcursor possible?
Date
Msg-id 4383E459.2070906@telogis.com
Whole thread Raw
Responses Re: Binary Refcursor possible?
List pgsql-performance
Hi,

I am trying to get better performance reading data from postgres, so I
would like to return the data as binary rather than text as parsing it
is taking a considerable amount of processor.

However I can't figure out how to do that! I have functions like.

function my_func(ret refcursor) returns refcursor AS

$$

BEGIN
OPEN $1 for select * from table;
return $1
END;

$$ language 'plpgsql'

There are queried using

SELECT my_func( 'ret'::refcursor); FETCH ALL FROM ret;

Is there any way I can say make ret a binary cursor?

Thanks
Ralph



pgsql-performance by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Hardware/OS recommendations for large databases (
Next
From: Alan Stange
Date:
Subject: Re: Hardware/OS recommendations for large databases (