Returning k rows would be a reasonable solution but which functions need to
be modified to achieve this.
----- Original Message -----
From: "Neil Conway" <neilc@samurai.com>
To: "Andrew Dunstan" <andrew@dunslane.net>
Cc: "Martijn van Oosterhout" <kleptog@svana.org>; "Islam Hegazy"
<islheg@hotmail.com>; <pgsql-hackers@postgresql.org>
Sent: Sunday, March 18, 2007 4:57 PM
Subject: Re: [HACKERS] modifying the tbale function
> Andrew Dunstan wrote:
>> I'm not convinced it would be a huge gain anyway. Switching madly in and
>> out of the perl interpreter at least is a known performance problem, IIRC
>
> Returning control to the backend for every row returned would likely be
> excessive, but you could return once every k rows and get most of the
> benefits of both approaches (k might be on the order of 1000). The problem
> with the current approach is that it makes returning large result sets
> from PL functions very expensive, since they need to be spooled to disk.
>
> As for using threads, that's pretty much a non-starter: we can't safely
> allow calls into the backend from multiple concurrent threads, and I doubt
> that will chance any time soon.
>
> -Neil
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
> http://archives.postgresql.org
>
