refcurosr vs. setof

From: Rüdiger Herrmann
Subject: refcurosr vs. setof
Date: ,
Msg-id: d3ugoo$2oq8$1@news.hub.org
(view: Whole thread, Raw)
Responses: Re: refcurosr vs. setof  (Michael Fuhr)
List: pgsql-performance

Hello,

I need to write several PL/pgSQL functions all returning a "result set" wich
can be obtained by a single SELECT statement.
For now the functions are called by a Java application.
Both REFCURSOR and SETOF serve my purpose, but I was wondering if there is a
perfonance difference between the two. The result set can become quite
large.

I hope not to ask this question the 1001 time, though I couldn't find
anything on the net.. Any hints are welcome.

Regards
R�diger




pgsql-performance by date:

From: Christopher Browne
Date:
Subject: Re: plperl vs plpgsql
From: "Nurlan Mukhanov (AL/EKZ)"
Date:
Subject: Postgresql works too slow