refcurosr vs. setof

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


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

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


pgsql-performance by date:

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